topic Re: displaying top 3 records in QlikView https://community.qlik.com/t5/QlikView/displaying-top-3-records/m-p/481145#M179842 <HTML><HEAD></HEAD><BODY><P>go to 'Dimension Limits' tab and select select largest 3 values. hope it will help.</P></BODY></HTML> Wed, 04 Sep 2013 12:09:22 GMT senpradip007 2013-09-04T12:09:22Z displaying top 3 records https://community.qlik.com/t5/QlikView/displaying-top-3-records/m-p/481144#M179841 <HTML><HEAD></HEAD><BODY><P>Hello Friends,</P><P></P><P>I want to display top three recors in my output.Can you please guide us what should be the expression for this.</P><P></P><P></P><P>Thanks,</P></BODY></HTML> Wed, 04 Sep 2013 11:59:01 GMT https://community.qlik.com/t5/QlikView/displaying-top-3-records/m-p/481144#M179841 deepakqlikview_123 2013-09-04T11:59:01Z Re: displaying top 3 records https://community.qlik.com/t5/QlikView/displaying-top-3-records/m-p/481145#M179842 <HTML><HEAD></HEAD><BODY><P>go to 'Dimension Limits' tab and select select largest 3 values. hope it will help.</P></BODY></HTML> Wed, 04 Sep 2013 12:09:22 GMT https://community.qlik.com/t5/QlikView/displaying-top-3-records/m-p/481145#M179842 senpradip007 2013-09-04T12:09:22Z Re: displaying top 3 records https://community.qlik.com/t5/QlikView/displaying-top-3-records/m-p/481146#M179843 <HTML><HEAD></HEAD><BODY><P>add dimentions</P><P>Grup_item</P><P>Shop_id</P><P>add calculated dimension</P><P>=Aggr(if(rank(sum([sum_sales]),4,1) &lt;= 3,Shop_ID,Null()),[Grup_item],Shop_id).</P><P><SPAN class="short_text" lang="en"><SPAN class="hps">Click</SPAN></SPAN> suppress when value is null</P><P>add expressions</P><P>sum([sum_sales])</P><P>Rezult: 3 Shop where max sum sales</P></BODY></HTML> Wed, 04 Sep 2013 13:21:02 GMT https://community.qlik.com/t5/QlikView/displaying-top-3-records/m-p/481146#M179843 yevgeniy 2013-09-04T13:21:02Z