topic Keeping rank static... in QlikView https://community.qlik.com/t5/QlikView/Keeping-rank-static/m-p/498395#M186228 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have this pivot chart where in have brands of different commpanies with their sales..</P><P>i have a rank code where in displaying rank according to the sales...</P><P></P><P>When i select a certaian company and suppose it has three brans with different ranks....but the ranking starts again from 1 and so on...</P><P>I want that even if i select brand or company the rank for that brand should remain static...</P><P>I am attaching sample data...</P><P></P><P>Thanks and Regards,</P><P>Rohit Yadav</P></BODY></HTML> Fri, 19 Jul 2013 04:24:39 GMT rohitians 2013-07-19T04:24:39Z Keeping rank static... https://community.qlik.com/t5/QlikView/Keeping-rank-static/m-p/498395#M186228 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have this pivot chart where in have brands of different commpanies with their sales..</P><P>i have a rank code where in displaying rank according to the sales...</P><P></P><P>When i select a certaian company and suppose it has three brans with different ranks....but the ranking starts again from 1 and so on...</P><P>I want that even if i select brand or company the rank for that brand should remain static...</P><P>I am attaching sample data...</P><P></P><P>Thanks and Regards,</P><P>Rohit Yadav</P></BODY></HTML> Fri, 19 Jul 2013 04:24:39 GMT https://community.qlik.com/t5/QlikView/Keeping-rank-static/m-p/498395#M186228 rohitians 2013-07-19T04:24:39Z Re: Keeping rank static... https://community.qlik.com/t5/QlikView/Keeping-rank-static/m-p/498396#M186229 <HTML><HEAD></HEAD><BODY><P>Try aggr(Rank(total (sum({1}Sales))),BRAND)</P></BODY></HTML> Fri, 19 Jul 2013 06:42:46 GMT https://community.qlik.com/t5/QlikView/Keeping-rank-static/m-p/498396#M186229 Gysbert_Wassenaar 2013-07-19T06:42:46Z Re: Keeping rank static... https://community.qlik.com/t5/QlikView/Keeping-rank-static/m-p/498397#M186230 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>It is working for the sample data but not for the actual one...</P><P></P><P>=Rank(total (SUM( {$&lt;FiscalYear={$(=max(FiscalYear))}&gt;} [Values])/10000000))</P><P></P><P>Thanks and Regards,</P><P>Rohit</P></BODY></HTML> Fri, 19 Jul 2013 07:09:10 GMT https://community.qlik.com/t5/QlikView/Keeping-rank-static/m-p/498397#M186230 rohitians 2013-07-19T07:09:10Z Re: Keeping rank static... https://community.qlik.com/t5/QlikView/Keeping-rank-static/m-p/498398#M186231 <HTML><HEAD></HEAD><BODY><P>Hi Please find attached qvw.</P></BODY></HTML> Fri, 19 Jul 2013 08:00:09 GMT https://community.qlik.com/t5/QlikView/Keeping-rank-static/m-p/498398#M186231 Anonymous 2013-07-19T08:00:09Z