7 Replies Latest reply: Mar 5, 2015 12:04 PM by Howard Lask RSS

    How to create a persistent rank in a pivot

      Hi,

       

      I am developing a stock sorting and filtering application in QlikSense.  I have a statistic called RS to which I want to apply a rank. The rank needs to persist when I apply an industry selection to my stocks.

      Here is a screenshot of my app:

      Screen1.JPG

      I have written a measure to achieve this:

      RankRSGlobal = rank(sum({1<Industry= >}RS),1,1)

      which works as required and displays the persistent rank however the stocks are not filtered when the industry is selected - I see all stocks and the value where the Stock matches the selected Industry:

      Screen2.JPG

      Any tips on how to achieve a filtered stock list with the persistent rank?

       

      Many thanks

       

      Howard