topic Re: Ton n analysis in QlikView https://community.qlik.com/t5/QlikView/Ton-n-analysis/m-p/1147429#M911000 <HTML><HEAD></HEAD><BODY><P>Thanks. but i am able to achieve this using the aggr function by your directions.</P><P></P><P>but how can i show others at the bottom..like we do in dimension limits????</P></BODY></HTML> Mon, 13 Jun 2016 08:08:41 GMT gauthamchilled 2016-06-13T08:08:41Z Ton n analysis https://community.qlik.com/t5/QlikView/Ton-n-analysis/m-p/1147426#M910997 <HTML><HEAD></HEAD><BODY><P>hi </P><P></P><P>how to create to top n analysis with multiple dimensions. </P><P>looks it will work only for 1 dimension</P><P></P><P>Can you any one give example?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Ton-n-analysis/m-p/1147426#M910997 gauthamchilled 2020-11-25T16:16:04Z Re: Ton n analysis https://community.qlik.com/t5/QlikView/Ton-n-analysis/m-p/1147427#M910998 <HTML><HEAD></HEAD><BODY><P>I think you need to make use of the <STRONG>Aggr() function with all the necessary dimension </STRONG></P><P><STRONG>eg: AGGR(sum(sales),Dim1,Dim2,Dim3) and use RANK function along with to achieve the desired results </STRONG></P><P></P><P><A href="https://community.qlik.com/thread/16178">Top N list with 2 dimensions</A></P><P><A href="https://community.qlik.com/thread/115247">Top N in Pivot/Straight table with multiple dimension</A></P></BODY></HTML> Wed, 08 Jun 2016 07:14:12 GMT https://community.qlik.com/t5/QlikView/Ton-n-analysis/m-p/1147427#M910998 avinashelite 2016-06-08T07:14:12Z Re: Ton n analysis https://community.qlik.com/t5/QlikView/Ton-n-analysis/m-p/1147428#M910999 <HTML><HEAD></HEAD><BODY><P>see this</P><P></P><P><A href="https://community.qlik.com/thread/16178">Top N list with 2 dimensions</A></P></BODY></HTML> Wed, 08 Jun 2016 07:15:46 GMT https://community.qlik.com/t5/QlikView/Ton-n-analysis/m-p/1147428#M910999 Kushal_Chawda 2016-06-08T07:15:46Z Re: Ton n analysis https://community.qlik.com/t5/QlikView/Ton-n-analysis/m-p/1147429#M911000 <HTML><HEAD></HEAD><BODY><P>Thanks. but i am able to achieve this using the aggr function by your directions.</P><P></P><P>but how can i show others at the bottom..like we do in dimension limits????</P></BODY></HTML> Mon, 13 Jun 2016 08:08:41 GMT https://community.qlik.com/t5/QlikView/Ton-n-analysis/m-p/1147429#M911000 gauthamchilled 2016-06-13T08:08:41Z Re: Ton n analysis https://community.qlik.com/t5/QlikView/Ton-n-analysis/m-p/1147430#M911001 <HTML><HEAD></HEAD><BODY><P>Bump</P></BODY></HTML> Mon, 13 Jun 2016 12:03:42 GMT https://community.qlik.com/t5/QlikView/Ton-n-analysis/m-p/1147430#M911001 gauthamchilled 2016-06-13T12:03:42Z