Hi,
I'm very very new to Qlikview and was trying to find out the following:
I have the following imported from Excel roughly:
HG | 0-15 | 16-17 | 18-19 | 20-29 |
---|
A | 2 | 5 | 5 | 16 |
B | 44 | 2 | 2 | 3 |
C | 3 | 25 | 33 | 4 |
D | 2 | 11 | 22 | 1 |
E | 14 | 4 | 4 | 8 |
I'm trying to build a bar chart that calculates the total for HG regardless of which dimension is selected and then
order the chart by the sum of each expression, ie Chart should look like this in chart format:
18-19 | 0-15 | 16-17 | 20-29 |
---|
66 | 65 | 47 | 32 |
I'd also like to limit this to the first returned value i.e.
I'm basically tying to show the most common group for HG based on the sum of each individual group.
Anyway of doing this in a Bar chart in Qlik, I've tried multiple ways but seem to be going around in a circle. I've tried RangeMax, Rank among others but can't seem to get it to work exactly as expected.
Any help would be much appreciated
Thanks