Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Instead of checking 'Relative' option, try using this expression
Sum(Sales)/Sum(TOTAL <Mes> Sales)
Instead of checking 'Relative' option, try using this expression
Sum(Sales)/Sum(TOTAL <Mes> Sales)
Awesome!!! It worked great!