topic Re: show first rank in QlikView https://community.qlik.com/t5/QlikView/show-first-rank/m-p/1127410#M370984 <HTML><HEAD></HEAD><BODY><P>Tanks Kushal</P></BODY></HTML> Thu, 16 Jun 2016 06:57:45 GMT omid5ive 2016-06-16T06:57:45Z show first rank https://community.qlik.com/t5/QlikView/show-first-rank/m-p/1127404#M370978 <HTML><HEAD></HEAD><BODY><P>hi</P><P>how can i show the branch with highest sale in label?</P></BODY></HTML> Thu, 16 Jun 2016 06:48:36 GMT https://community.qlik.com/t5/QlikView/show-first-rank/m-p/1127404#M370978 omid5ive 2016-06-16T06:48:36Z Re: show first rank https://community.qlik.com/t5/QlikView/show-first-rank/m-p/1127405#M370979 <HTML><HEAD></HEAD><BODY><P>Hi omid,</P><P>Try this expression,</P><P><STRONG>Num(Aggr(Rank(Sum({1} "Measure"),4),"Dimension"))</STRONG></P></BODY></HTML> Thu, 16 Jun 2016 06:52:47 GMT https://community.qlik.com/t5/QlikView/show-first-rank/m-p/1127405#M370979 susovan 2016-06-16T06:52:47Z Re: show first rank https://community.qlik.com/t5/QlikView/show-first-rank/m-p/1127406#M370980 <HTML><HEAD></HEAD><BODY><P>rank(sum(Sales))</P></BODY></HTML> Thu, 16 Jun 2016 06:53:44 GMT https://community.qlik.com/t5/QlikView/show-first-rank/m-p/1127406#M370980 vikasmahajan 2016-06-16T06:53:44Z Re: show first rank https://community.qlik.com/t5/QlikView/show-first-rank/m-p/1127407#M370981 <HTML><HEAD></HEAD><BODY><P>Dimension = Month</P><P>Expressions </P><P>FirstSortedValue(Product, -Quantity)</P><P>FirstSortedValue(Quantity, -Quantity)</P><P>&nbsp;&nbsp; <SPAN class="acclaim-like-container js-acclaim-container acclaim-container" data-can-like="true" data-likes="0" data-ratingtype="like" data-type="small">&nbsp; <A _jive_internal="true" class="jive-acclaim-likelink" data-command="like" data-object-id="487056" data-object-type="2" href="https://community.qlik.com/message/491647"> <SPAN class="jive-icon-sml jive-icon-like">&nbsp; </SPAN></A></SPAN></P></BODY></HTML> Thu, 16 Jun 2016 06:54:32 GMT https://community.qlik.com/t5/QlikView/show-first-rank/m-p/1127407#M370981 vikasmahajan 2016-06-16T06:54:32Z Re: show first rank https://community.qlik.com/t5/QlikView/show-first-rank/m-p/1127408#M370982 <HTML><HEAD></HEAD><BODY><P>i used this:</P><P>=num(Aggr(Rank(Sum({1} L_COUNT),4),PROVIENCE_NAME))</P><P>but it doesnt show any thing<IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /></P></BODY></HTML> Thu, 16 Jun 2016 06:55:04 GMT https://community.qlik.com/t5/QlikView/show-first-rank/m-p/1127408#M370982 omid5ive 2016-06-16T06:55:04Z Re: show first rank https://community.qlik.com/t5/QlikView/show-first-rank/m-p/1127409#M370983 <HTML><HEAD></HEAD><BODY><P>=FirstSortedValue(Branch, -aggr(sum(Sales),Brach))</P></BODY></HTML> Thu, 16 Jun 2016 06:56:26 GMT https://community.qlik.com/t5/QlikView/show-first-rank/m-p/1127409#M370983 Kushal_Chawda 2016-06-16T06:56:26Z Re: show first rank https://community.qlik.com/t5/QlikView/show-first-rank/m-p/1127410#M370984 <HTML><HEAD></HEAD><BODY><P>Tanks Kushal</P></BODY></HTML> Thu, 16 Jun 2016 06:57:45 GMT https://community.qlik.com/t5/QlikView/show-first-rank/m-p/1127410#M370984 omid5ive 2016-06-16T06:57:45Z Re: show first rank https://community.qlik.com/t5/QlikView/show-first-rank/m-p/1127411#M370985 <HTML><HEAD></HEAD><BODY><P>Welcome <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 16 Jun 2016 07:01:30 GMT https://community.qlik.com/t5/QlikView/show-first-rank/m-p/1127411#M370985 Kushal_Chawda 2016-06-16T07:01:30Z