Dimensionless - order by multiple expressions

Wed, 31 May 2017 13:53:57 GMT

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.

18-19
66

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

topic Dimensionless - order by multiple expressions in QlikView

Dimensionless - order by multiple expressions