0 Replies Latest reply: May 31, 2017 9:53 AM by Paul Bennett RSS

    Dimensionless - order by multiple expressions

    Paul Bennett

      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