topic Re: Get Top 2 in QlikView https://community.qlik.com/t5/QlikView/Get-Top-2/m-p/1042853#M350835 <HTML><HEAD></HEAD><BODY><P>=if(Aggr((Count(Application) / Count(DISTINCT Rating)),Customer) &gt;= 2,Customer)</P></BODY></HTML> Sun, 03 Apr 2016 09:29:27 GMT Anonymous 2016-04-03T09:29:27Z Get Top 2 https://community.qlik.com/t5/QlikView/Get-Top-2/m-p/1042852#M350834 <HTML><HEAD></HEAD><BODY><P>Hi Friends,</P><P></P><P>I have a dataset shown in the first table and second table (See Image Screen_Shot.jpg) was created using CROSSTABLE keyword.</P><P>Now i want to get the top 2 application based on Rating where # of Survey is greater than 1.</P></BODY></HTML> Sun, 03 Apr 2016 08:31:51 GMT https://community.qlik.com/t5/QlikView/Get-Top-2/m-p/1042852#M350834 Anonymous 2016-04-03T08:31:51Z Re: Get Top 2 https://community.qlik.com/t5/QlikView/Get-Top-2/m-p/1042853#M350835 <HTML><HEAD></HEAD><BODY><P>=if(Aggr((Count(Application) / Count(DISTINCT Rating)),Customer) &gt;= 2,Customer)</P></BODY></HTML> Sun, 03 Apr 2016 09:29:27 GMT https://community.qlik.com/t5/QlikView/Get-Top-2/m-p/1042853#M350835 Anonymous 2016-04-03T09:29:27Z