topic Rank within set analysis not working with proper limit in App Development https://community.qlik.com/t5/App-Development/Rank-within-set-analysis-not-working-with-proper-limit/m-p/1350498#M30067 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I am using Qlik Sense jun-2017 server version.</P><P></P><P>My objective is to get total sales values of top 10 users out of Top 20 users set by Dimension Limitation(Fixed Number = 20).</P><P>Have written the expression as:</P><P></P><P><STRONG>SUM(total{&lt;contact_id = {"=Rank(SUM(sales),4)&lt;=10"}&gt;}sales)</STRONG></P><P></P><P>This is resulting sales value upto top 9 users. But if change the expression to</P><P></P><P><SPAN style="font-size: 10pt;"> </SPAN><STRONG style="font-size: 10pt;">SUM(total{&lt;contact_id = {"=Rank(SUM(sales),4)&lt;12"}&gt;}sales) </STRONG>giving the correct result.</P><P></P><P>Can anyone please explain why limit of the Rank is not working properly within set ?</P><P></P><P>Please find the attached data for detail clarification.</P><P></P><P>Regards,</P><P>som</P></BODY></HTML> Fri, 21 Jul 2017 09:01:18 GMT somenathroy 2017-07-21T09:01:18Z Rank within set analysis not working with proper limit https://community.qlik.com/t5/App-Development/Rank-within-set-analysis-not-working-with-proper-limit/m-p/1350498#M30067 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I am using Qlik Sense jun-2017 server version.</P><P></P><P>My objective is to get total sales values of top 10 users out of Top 20 users set by Dimension Limitation(Fixed Number = 20).</P><P>Have written the expression as:</P><P></P><P><STRONG>SUM(total{&lt;contact_id = {"=Rank(SUM(sales),4)&lt;=10"}&gt;}sales)</STRONG></P><P></P><P>This is resulting sales value upto top 9 users. But if change the expression to</P><P></P><P><SPAN style="font-size: 10pt;"> </SPAN><STRONG style="font-size: 10pt;">SUM(total{&lt;contact_id = {"=Rank(SUM(sales),4)&lt;12"}&gt;}sales) </STRONG>giving the correct result.</P><P></P><P>Can anyone please explain why limit of the Rank is not working properly within set ?</P><P></P><P>Please find the attached data for detail clarification.</P><P></P><P>Regards,</P><P>som</P></BODY></HTML> Fri, 21 Jul 2017 09:01:18 GMT https://community.qlik.com/t5/App-Development/Rank-within-set-analysis-not-working-with-proper-limit/m-p/1350498#M30067 somenathroy 2017-07-21T09:01:18Z