Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Not applicable

Dimensionless - order by multiple expressions

Hi,

I'm very very new to Qlikview and was trying to find out the following:

I have the following imported from Excel roughly:

HG0-1516-1718-1920-29

A

25516
B44223
C325334
D211221
E14448

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-190-1516-1720-29
66654732

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