Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

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.

Capture.PNG

I'm running QlikView 12.20.20100.0

1 Solution

Accepted Solutions
sunny_talwar

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

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

View solution in original post

2 Replies
sunny_talwar

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

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

Anonymous
Not applicable
Author

Awesome!!! It worked great!