topic Re: top 3 values in QlikView https://community.qlik.com/t5/QlikView/top-3-values/m-p/44503#M787909 <HTML><HEAD></HEAD><BODY><P>Please see the attached and hope this helps..</P><P></P><P><IMG alt="Top 3 Invoices using Aggr and Rank.jpg" class="jive-image image-1" src="/legacyfs/online/193710_Top 3 Invoices using Aggr and Rank.jpg" style="height: auto;" /></P></BODY></HTML> Sun, 18 Feb 2018 13:53:48 GMT trdandamudi 2018-02-18T13:53:48Z top 3 values https://community.qlik.com/t5/QlikView/top-3-values/m-p/44500#M787906 <HTML><HEAD></HEAD><BODY><P>hi all , I have requirement to show top 3 invoice numbers based Company and Region on my expression.</P><P></P><P>Exp:</P><P> For every Company and Region combination I need top 3 invoice numbers by default without any selection.</P><P></P><P></P><P>Can anyone tell me how to achieve this in qlikview ?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/top-3-values/m-p/44500#M787906 subbareddykm 2020-11-25T16:16:04Z Re: top 3 values https://community.qlik.com/t5/QlikView/top-3-values/m-p/44501#M787907 <HTML><HEAD></HEAD><BODY><P>use can aggr function</P></BODY></HTML> Sun, 18 Feb 2018 11:30:49 GMT https://community.qlik.com/t5/QlikView/top-3-values/m-p/44501#M787907 manu1512 2018-02-18T11:30:49Z Re: top 3 values https://community.qlik.com/t5/QlikView/top-3-values/m-p/44502#M787908 <HTML><HEAD></HEAD><BODY><P>I tried but no luck</P><P></P><P></P><P>can try with my app?</P></BODY></HTML> Sun, 18 Feb 2018 11:39:13 GMT https://community.qlik.com/t5/QlikView/top-3-values/m-p/44502#M787908 subbareddykm 2018-02-18T11:39:13Z Re: top 3 values https://community.qlik.com/t5/QlikView/top-3-values/m-p/44503#M787909 <HTML><HEAD></HEAD><BODY><P>Please see the attached and hope this helps..</P><P></P><P><IMG alt="Top 3 Invoices using Aggr and Rank.jpg" class="jive-image image-1" src="/legacyfs/online/193710_Top 3 Invoices using Aggr and Rank.jpg" style="height: auto;" /></P></BODY></HTML> Sun, 18 Feb 2018 13:53:48 GMT https://community.qlik.com/t5/QlikView/top-3-values/m-p/44503#M787909 trdandamudi 2018-02-18T13:53:48Z Re: top 3 values https://community.qlik.com/t5/QlikView/top-3-values/m-p/44504#M787910 <HTML><HEAD></HEAD><BODY><P>Concate both country and region to form a new column i.e dimension and then use dimension limit or Aggr rank combination</P></BODY></HTML> Sun, 18 Feb 2018 16:16:13 GMT https://community.qlik.com/t5/QlikView/top-3-values/m-p/44504#M787910 passionate 2018-02-18T16:16:13Z Re: top 3 values https://community.qlik.com/t5/QlikView/top-3-values/m-p/44505#M787911 <HTML><HEAD></HEAD><BODY><P>Its not giving the result which I ma expecting .</P><P></P><P>Example :</P><P>For Comp = A and Region = W , I have 6 Inv No ,I want only 3 Inv No which are have high value.</P><P></P><P></P><P>I hope you understood.</P></BODY></HTML> Sun, 18 Feb 2018 17:23:31 GMT https://community.qlik.com/t5/QlikView/top-3-values/m-p/44505#M787911 subbareddykm 2018-02-18T17:23:31Z Re: top 3 values https://community.qlik.com/t5/QlikView/top-3-values/m-p/44506#M787912 <HTML><HEAD></HEAD><BODY><P>May be try like:</P><P></P><P>= IF(Aggr(Rank(Sum(InvNo)), Comp, Region)&lt;=3, InvNo)</P></BODY></HTML> Sun, 18 Feb 2018 18:40:27 GMT https://community.qlik.com/t5/QlikView/top-3-values/m-p/44506#M787912 vishsaggi 2018-02-18T18:40:27Z Re: top 3 values https://community.qlik.com/t5/QlikView/top-3-values/m-p/44507#M787913 <HTML><HEAD></HEAD><BODY><P>Please take a look at the attached...</P></BODY></HTML> Sun, 18 Feb 2018 23:48:16 GMT https://community.qlik.com/t5/QlikView/top-3-values/m-p/44507#M787913 trdandamudi 2018-02-18T23:48:16Z