Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
juan_escobar
Creator II
Creator II

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)

View solution in original post

juan_escobar
Creator II
Creator II
Author

Awesome!!! It worked great!