How to aggregate a relative expression by bar in a bar chart

[Anonymous]

Hi guys!

I have been working on this bar chart, where I have 2 dimensions: month and a channel classification. I'm using a Sum(Sales) expression ad checked the relative option.

In the Presentation tab I checked the plot values inside segments and still show total on top. I realized that the chart is applying the relative expression all over the dimensions, I want to have it by month.

See the image below: each month has an average of 9%, I want each month to be 100% splitted into both channels.

I'm running QlikView 12.20.20100.0

[sunny_talwar · Accepted solution]

Instead of checking 'Relative' option, try using this expression

Sum(Sales)/Sum(TOTAL <Mes> Sales)

[Anonymous]

Awesome!!! It worked great!