0 Replies Latest reply: Jul 21, 2017 5:01 AM by Some Nath Roy RSS

    Rank within set analysis not working with proper limit

    Some Nath Roy

      Hi All,

       

      I am using Qlik Sense jun-2017 server version.

       

      My objective is to get total sales values of top 10 users out of Top 20 users set by Dimension Limitation(Fixed Number = 20).

      Have written the expression as:

       

      SUM(total{<contact_id = {"=Rank(SUM(sales),4)<=10"}>}sales)

       

      This is resulting sales value upto top 9 users. But if change the expression to

       

      SUM(total{<contact_id = {"=Rank(SUM(sales),4)<12"}>}sales) giving the correct result.

       

      Can anyone please explain why limit of the Rank is not working properly within set ?

       

      Please find the attached data for detail clarification.

       

      Regards,

      som