topic Re: Calculation For Top N in QlikView https://community.qlik.com/t5/QlikView/Calculation-For-Top-N/m-p/876284#M996606 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Use Dimiension Limits and disable Totals in Expressions so that you get the desired output.\</P><P></P><P>Find the attachment.</P></BODY></HTML> Tue, 23 Jun 2015 03:52:09 GMT hariprasadqv 2015-06-23T03:52:09Z Calculation For Top N https://community.qlik.com/t5/QlikView/Calculation-For-Top-N/m-p/876280#M996602 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P></P><P>Is there any way by which i can get top N entity in the straight table eg. Top 10, and total that is displayed on top of that will be the total of only top 10 and not cumulative total of all.</P><P></P><P>Thanks in advance</P></BODY></HTML> Tue, 23 Jun 2015 03:04:35 GMT https://community.qlik.com/t5/QlikView/Calculation-For-Top-N/m-p/876280#M996602 md_qlikview 2015-06-23T03:04:35Z Re: Calculation For Top N https://community.qlik.com/t5/QlikView/Calculation-For-Top-N/m-p/876281#M996603 <HTML><HEAD></HEAD><BODY><P>Try Dimenssion limits</P></BODY></HTML> Tue, 23 Jun 2015 03:18:50 GMT https://community.qlik.com/t5/QlikView/Calculation-For-Top-N/m-p/876281#M996603 2015-06-23T03:18:50Z Re: Calculation For Top N https://community.qlik.com/t5/QlikView/Calculation-For-Top-N/m-p/876282#M996604 <HTML><HEAD></HEAD><BODY><P>it gives cumulative total and not total of top n. i want total of only top n.</P></BODY></HTML> Tue, 23 Jun 2015 03:33:15 GMT https://community.qlik.com/t5/QlikView/Calculation-For-Top-N/m-p/876282#M996604 md_qlikview 2015-06-23T03:33:15Z Re: Calculation For Top N https://community.qlik.com/t5/QlikView/Calculation-For-Top-N/m-p/876283#M996605 <HTML><HEAD></HEAD><BODY><P>Deselect the option 'Show others' from dimension limits. This will give you the total only for top values.</P></BODY></HTML> Tue, 23 Jun 2015 03:50:49 GMT https://community.qlik.com/t5/QlikView/Calculation-For-Top-N/m-p/876283#M996605 vivek_niti 2015-06-23T03:50:49Z Re: Calculation For Top N https://community.qlik.com/t5/QlikView/Calculation-For-Top-N/m-p/876284#M996606 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Use Dimiension Limits and disable Totals in Expressions so that you get the desired output.\</P><P></P><P>Find the attachment.</P></BODY></HTML> Tue, 23 Jun 2015 03:52:09 GMT https://community.qlik.com/t5/QlikView/Calculation-For-Top-N/m-p/876284#M996606 hariprasadqv 2015-06-23T03:52:09Z Re: Calculation For Top N https://community.qlik.com/t5/QlikView/Calculation-For-Top-N/m-p/876285#M996607 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Try this Calculated Dimension</P><P></P><P>=If(Aggr(Rank(SUM(MeasureName), 4, 0), DimensionName) &lt;= 10, <SPAN style="font-size: 13.3333330154419px;">DimensionName</SPAN>)</P><P></P><P>Example:</P><P><SPAN style="font-size: 13.3333330154419px;">=If(Aggr(Rank(SUM(Sales), 4, 0), <SPAN style="font-size: 13.3333330154419px;">Customer</SPAN>) &lt;= 10, </SPAN><SPAN style="font-size: 13.3333330154419px;">Customer</SPAN><SPAN style="font-size: 13.3333330154419px;">)</SPAN></P><P><SPAN style="font-size: 13.3333330154419px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333330154419px;">Regards,</SPAN></P><P><SPAN style="font-size: 13.3333330154419px;">Jagan.<BR /></SPAN></P></BODY></HTML> Tue, 23 Jun 2015 04:07:56 GMT https://community.qlik.com/t5/QlikView/Calculation-For-Top-N/m-p/876285#M996607 jagan 2015-06-23T04:07:56Z Re: Calculation For Top N https://community.qlik.com/t5/QlikView/Calculation-For-Top-N/m-p/876286#M996609 <HTML><HEAD></HEAD><BODY><P>Please provide dimensions and expressions in report.</P></BODY></HTML> Tue, 23 Jun 2015 04:49:09 GMT https://community.qlik.com/t5/QlikView/Calculation-For-Top-N/m-p/876286#M996609 timanshu 2015-06-23T04:49:09Z