topic Re: Rank Function w.r.t multiple dimension is not working in QlikView https://community.qlik.com/t5/QlikView/Rank-Function-w-r-t-multiple-dimension-is-not-working/m-p/679109#M1058146 <HTML><HEAD></HEAD><BODY><P>not working for multiple dimension</P></BODY></HTML> Wed, 08 Oct 2014 10:16:03 GMT abhaysingh 2014-10-08T10:16:03Z Rank Function w.r.t multiple dimension is not working https://community.qlik.com/t5/QlikView/Rank-Function-w-r-t-multiple-dimension-is-not-working/m-p/679102#M1058139 <HTML><HEAD></HEAD><BODY><P>Rank function is not working with multiple dimension please find the sample data as well</P><P></P><P>kindly help...........</P><P></P><P>regards</P><P>abhay</P></BODY></HTML> Wed, 08 Oct 2014 07:47:58 GMT https://community.qlik.com/t5/QlikView/Rank-Function-w-r-t-multiple-dimension-is-not-working/m-p/679102#M1058139 abhaysingh 2014-10-08T07:47:58Z Re: Rank Function w.r.t multiple dimension is not working https://community.qlik.com/t5/QlikView/Rank-Function-w-r-t-multiple-dimension-is-not-working/m-p/679103#M1058140 <HTML><HEAD></HEAD><BODY><P>What is your expected output?</P></BODY></HTML> Wed, 08 Oct 2014 08:00:40 GMT https://community.qlik.com/t5/QlikView/Rank-Function-w-r-t-multiple-dimension-is-not-working/m-p/679103#M1058140 tresB 2014-10-08T08:00:40Z Re: Rank Function w.r.t multiple dimension is not working https://community.qlik.com/t5/QlikView/Rank-Function-w-r-t-multiple-dimension-is-not-working/m-p/679104#M1058141 <HTML><HEAD></HEAD><BODY><P>Attached qvw has only one dimension. Can you attach sample data</P></BODY></HTML> Wed, 08 Oct 2014 08:01:21 GMT https://community.qlik.com/t5/QlikView/Rank-Function-w-r-t-multiple-dimension-is-not-working/m-p/679104#M1058141 anbu1984 2014-10-08T08:01:21Z Re: Rank Function w.r.t multiple dimension is not working https://community.qlik.com/t5/QlikView/Rank-Function-w-r-t-multiple-dimension-is-not-working/m-p/679105#M1058142 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>First you need reload the file because dimension city isn't it.</P><P></P><P>Doesn't work because you don't have sales values in all the dimensions......</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333339691162px;">the same of Tresesco: What is your expected output?</SPAN></P><P></P><P>Regards,</P></BODY></HTML> Wed, 08 Oct 2014 08:07:07 GMT https://community.qlik.com/t5/QlikView/Rank-Function-w-r-t-multiple-dimension-is-not-working/m-p/679105#M1058142 sorrakis01 2014-10-08T08:07:07Z Re: Rank Function w.r.t multiple dimension is not working https://community.qlik.com/t5/QlikView/Rank-Function-w-r-t-multiple-dimension-is-not-working/m-p/679106#M1058143 <HTML><HEAD></HEAD><BODY><P>e.g</P><P>Cust Name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Cust Code&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Pre-Tax Value CY&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Rank-CY&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Pre- Tax Value LY&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Rank-LY</P><P>AA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 01&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 80&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>BB&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 02&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 120&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 130&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>CC&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 03&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 80&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 90&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp; </P><P>DD&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 04&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 150&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 120&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2</P><P></P><P>I WANT THE OUPUT LIKE THAT</P></BODY></HTML> Wed, 08 Oct 2014 08:13:37 GMT https://community.qlik.com/t5/QlikView/Rank-Function-w-r-t-multiple-dimension-is-not-working/m-p/679106#M1058143 abhaysingh 2014-10-08T08:13:37Z Re: Rank Function w.r.t multiple dimension is not working https://community.qlik.com/t5/QlikView/Rank-Function-w-r-t-multiple-dimension-is-not-working/m-p/679107#M1058144 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try this.</P><P></P><P>Regards</P></BODY></HTML> Wed, 08 Oct 2014 08:26:18 GMT https://community.qlik.com/t5/QlikView/Rank-Function-w-r-t-multiple-dimension-is-not-working/m-p/679107#M1058144 sorrakis01 2014-10-08T08:26:18Z Re: Re: Rank Function w.r.t multiple dimension is not working https://community.qlik.com/t5/QlikView/Rank-Function-w-r-t-multiple-dimension-is-not-working/m-p/679108#M1058145 <HTML><HEAD></HEAD><BODY><P>Use rank(TOTAL Sales)</P></BODY></HTML> Wed, 08 Oct 2014 09:00:27 GMT https://community.qlik.com/t5/QlikView/Rank-Function-w-r-t-multiple-dimension-is-not-working/m-p/679108#M1058145 anbu1984 2014-10-08T09:00:27Z Re: Rank Function w.r.t multiple dimension is not working https://community.qlik.com/t5/QlikView/Rank-Function-w-r-t-multiple-dimension-is-not-working/m-p/679109#M1058146 <HTML><HEAD></HEAD><BODY><P>not working for multiple dimension</P></BODY></HTML> Wed, 08 Oct 2014 10:16:03 GMT https://community.qlik.com/t5/QlikView/Rank-Function-w-r-t-multiple-dimension-is-not-working/m-p/679109#M1058146 abhaysingh 2014-10-08T10:16:03Z Re: Rank Function w.r.t multiple dimension is not working https://community.qlik.com/t5/QlikView/Rank-Function-w-r-t-multiple-dimension-is-not-working/m-p/679110#M1058147 <HTML><HEAD></HEAD><BODY><P>Can you post qvw which you tried</P></BODY></HTML> Wed, 08 Oct 2014 10:20:26 GMT https://community.qlik.com/t5/QlikView/Rank-Function-w-r-t-multiple-dimension-is-not-working/m-p/679110#M1058147 anbu1984 2014-10-08T10:20:26Z Re: Rank Function w.r.t multiple dimension is not working https://community.qlik.com/t5/QlikView/Rank-Function-w-r-t-multiple-dimension-is-not-working/m-p/679111#M1058148 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Then i don't understand you because the file make the same of your example.</P><P></P><P>Sorry and Regards</P></BODY></HTML> Wed, 08 Oct 2014 10:22:04 GMT https://community.qlik.com/t5/QlikView/Rank-Function-w-r-t-multiple-dimension-is-not-working/m-p/679111#M1058148 sorrakis01 2014-10-08T10:22:04Z Re: Rank Function w.r.t multiple dimension is not working https://community.qlik.com/t5/QlikView/Rank-Function-w-r-t-multiple-dimension-is-not-working/m-p/679112#M1058149 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 8pt;">Thanks every one its done for CY but facing problem in LY.</SPAN></P><P> </P><P><SPAN style="font-size: 8pt;">my PY expression is below</SPAN></P><P> </P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">YEAR</SPAN><SPAN style="font-size: 8pt;"> = , </SPAN><SPAN style="color: #800000; font-size: 8pt;">fYear</SPAN><SPAN style="font-size: 8pt;">={</SPAN><STRONG><EM style=": ; color: #808080; font-size: 8pt;">$(vPreviousYear)</EM></STRONG><SPAN style="font-size: 8pt;">}&gt;} </SPAN><SPAN style="color: #800000; font-size: 8pt;">[Pre-Tax Value]</SPAN><SPAN style="font-size: 8pt;">)&nbsp; </SPAN></P><P> </P><P> </P><P><SPAN style="font-size: 8pt;">please help in expression for calculating rank function of it.</SPAN></P></BODY></HTML> Wed, 08 Oct 2014 10:32:24 GMT https://community.qlik.com/t5/QlikView/Rank-Function-w-r-t-multiple-dimension-is-not-working/m-p/679112#M1058149 abhaysingh 2014-10-08T10:32:24Z