Qlikview expression for percentage of bar (not total) in stacked bar chart

Viewed 2610

New to Qlikview, not yet familiar with scripting. My data has two dimensions, Month and HSETimes (4 categories), and the expression is Count(HSETimes). A stacked bar chart using relative values returns the percentage of the total by month by category.

I need an expression to return each months total as 100% with each category proportionately represented to produce a bar chart similar to the attached image, but I do not know how to write the expression: have tried many combinations of subset and total to no avail. Should be simple: can anyone help? ChartSample

1 Answers
Related