topic Re: Set analysis in QlikView https://community.qlik.com/t5/QlikView/Set-analysis/m-p/671180#M243817 <HTML><HEAD></HEAD><BODY><P>Isn't this the same question as in your other thread? Please try to avoid duplicate posts.</P><P></P><P>Try</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">=sum({&lt;City = {"=rank(sum(Quantity))&lt;=20"}&gt;} Quantity)</SPAN></P></BODY></HTML> Sat, 28 Jun 2014 08:38:01 GMT swuehl 2014-06-28T08:38:01Z Set analysis https://community.qlik.com/t5/QlikView/Set-analysis/m-p/671179#M243816 <HTML><HEAD></HEAD><BODY><P>I want to show sum of sales for top 20 city can you please tell me how to do that using set analysis</P></BODY></HTML> Sat, 28 Jun 2014 08:32:34 GMT https://community.qlik.com/t5/QlikView/Set-analysis/m-p/671179#M243816 deepakqlikview_123 2014-06-28T08:32:34Z Re: Set analysis https://community.qlik.com/t5/QlikView/Set-analysis/m-p/671180#M243817 <HTML><HEAD></HEAD><BODY><P>Isn't this the same question as in your other thread? Please try to avoid duplicate posts.</P><P></P><P>Try</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">=sum({&lt;City = {"=rank(sum(Quantity))&lt;=20"}&gt;} Quantity)</SPAN></P></BODY></HTML> Sat, 28 Jun 2014 08:38:01 GMT https://community.qlik.com/t5/QlikView/Set-analysis/m-p/671180#M243817 swuehl 2014-06-28T08:38:01Z Re: Set analysis https://community.qlik.com/t5/QlikView/Set-analysis/m-p/671181#M243818 <HTML><HEAD></HEAD><BODY><P>Sum(Sales) in expression...</P><P>In Dimension limit tab--&gt; Check limit the number of values to be shown</P><P>--&gt;Choose show only--&gt; Select Largest and give 20 as value</P></BODY></HTML> Sat, 28 Jun 2014 09:29:36 GMT https://community.qlik.com/t5/QlikView/Set-analysis/m-p/671181#M243818 2014-06-28T09:29:36Z