4 Replies Latest reply: Jul 14, 2015 3:03 PM by Stefan Wühl RSS

    Sorting the expression on 2 metrics

    Jaswanth Polisetti

      Hi,

      Hope all are doing good!

       

      My requirement is, I need to the rank the dimension on two metrics in my straight table. Consider there are two metrics in the table and the metrics are Lives and Market Share. So I need to rank the dimension and the first Rank should be calculated as Max(Lives) + less(Market Share) will be Rank 1. Please refer below example.

       

      RankLivesMarket Share
      150020%
      2

      400

      40%
      320050%
      410080

      So the rank 1 should be max(Lives) and less(Market Share).

       

      Can we have any way to write the rank expression in the above way in QlikView?

       

      Thanks,

      Polisetti