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

    How to create a persistent rank in a pivot



      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:


      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:


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


      Many thanks