topic Re: Rank, Textbox, Set Analysis in QlikView https://community.qlik.com/t5/QlikView/Rank-Textbox-Set-Analysis/m-p/1084643#M918343 <HTML><HEAD></HEAD><BODY><P>May be something like this:</P><P></P><P><STRONG>=FirstSortedValue(Item, -Aggr(Count(Item), Item))</STRONG></P></BODY></HTML> Fri, 06 May 2016 15:17:53 GMT sunny_talwar 2016-05-06T15:17:53Z Rank, Textbox, Set Analysis https://community.qlik.com/t5/QlikView/Rank-Textbox-Set-Analysis/m-p/1084642#M918342 <HTML><HEAD></HEAD><BODY><P>I've 3 columns</P><P></P><P>Customer&nbsp;&nbsp;&nbsp;&nbsp; Cust Rating&nbsp;&nbsp;&nbsp;&nbsp; Item</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Great&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Pen</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Good&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Pencil<BR />A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Bad&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Eraser<BR />A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Great&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Ink</P><P style="font-size: 13.3333px;">B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Great&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Pen</P><P style="font-size: 13.3333px;">B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Good&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Pen<BR />B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Bad&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Pencil<BR />B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Avg&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Eraser</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">I would like to show the Rank 1 item based on Great Customer Rating in a text box for all the customers.</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">For example, In the above table, Customer A &amp; B ordered 8 products out of which they rated 'Great' 3 times. Pen was rated Great twice.</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">How can I show that in a text box and not a table?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Rank-Textbox-Set-Analysis/m-p/1084642#M918342 Anonymous 2020-11-25T16:16:04Z Re: Rank, Textbox, Set Analysis https://community.qlik.com/t5/QlikView/Rank-Textbox-Set-Analysis/m-p/1084643#M918343 <HTML><HEAD></HEAD><BODY><P>May be something like this:</P><P></P><P><STRONG>=FirstSortedValue(Item, -Aggr(Count(Item), Item))</STRONG></P></BODY></HTML> Fri, 06 May 2016 15:17:53 GMT https://community.qlik.com/t5/QlikView/Rank-Textbox-Set-Analysis/m-p/1084643#M918343 sunny_talwar 2016-05-06T15:17:53Z