topic Set Analysis Question: Top 20 customers v. everyone else in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-Question-Top-20-customers-v-everyone-else/m-p/237730#M88749 <HTML><HEAD></HEAD><BODY><P>I'd like to build some dashboards that compare the top 20 customers to everyone else. Top 20 may change depending on which filters are selected. Can this be done? How would I use set analysis to select top 20 vs. those not in top 20?</P></BODY></HTML> Tue, 11 May 2010 15:24:26 GMT 2010-05-11T15:24:26Z Set Analysis Question: Top 20 customers v. everyone else https://community.qlik.com/t5/QlikView/Set-Analysis-Question-Top-20-customers-v-everyone-else/m-p/237730#M88749 <HTML><HEAD></HEAD><BODY><P>I'd like to build some dashboards that compare the top 20 customers to everyone else. Top 20 may change depending on which filters are selected. Can this be done? How would I use set analysis to select top 20 vs. those not in top 20?</P></BODY></HTML> Tue, 11 May 2010 15:24:26 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Question-Top-20-customers-v-everyone-else/m-p/237730#M88749 2010-05-11T15:24:26Z Set Analysis Question: Top 20 customers v. everyone else https://community.qlik.com/t5/QlikView/Set-Analysis-Question-Top-20-customers-v-everyone-else/m-p/237731#M88750 <HTML><HEAD></HEAD><BODY><P>Here's one way. I THINK the ranking will respect your other selections, but I haven't verified.</P><P style="padding-left:30px;">sum({&lt;Customer={"=rank(sum(Sales))&lt;=20"}&gt;} Sales)<BR />sum({&lt;Customer={"=rank(sum(Sales))&gt; 20"}&gt;} Sales)</P></BODY></HTML> Tue, 11 May 2010 23:50:26 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Question-Top-20-customers-v-everyone-else/m-p/237731#M88750 johnw 2010-05-11T23:50:26Z