topic Re: Rank Function with Multiple dimensions in App Development

topic Re: Rank Function with Multiple dimensions in App Development https://community.qlik.com/t5/App-Development/Rank-Function-with-Multiple-dimensions/m-p/12212#M863 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Yes I tried that before but it does not work.</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">I think there is something to do with my expression.</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Here is my expression:</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">(if(sum({<$(vRollingMonthsGeneral)>}(msrConvenienceIndexQuestionPoints1))>0,</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">sum({<$(vRollingMonthsGeneral)>}(msrConvenienceIndexIndexScore1))/</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">sum({<$(vRollingMonthsGeneral)>}(msrConvenienceIndexQuestionPoints1)),0)</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">+</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">if(sum({<$(vRollingMonthsGeneral)>}(msrTreatmentIndexQuestionPoints1))>0,</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">sum({<$(vRollingMonthsGeneral)>}(msrTreatmentIndexIndexScore1))/</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">sum({<$(vRollingMonthsGeneral)>}(msrTreatmentIndexQuestionPoints1)),0)</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">+</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">if(sum({<$(vRollingMonthsGeneral)>}(msrValueIndexQuestionPoints1))>0,</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">sum({<$(vRollingMonthsGeneral)>}(msrValueIndexIndexScore1))/</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">sum({<$(vRollingMonthsGeneral)>}(msrValueIndexQuestionPoints1)),0)</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">+</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">if(sum({<$(vRollingMonthsGeneral)>}(msrQualityIndexQuestionPoints1))>0,</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">sum({<$(vRollingMonthsGeneral)>}(msrQualityIndexIndexScore1))/</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">sum({<$(vRollingMonthsGeneral)>}(msrQualityIndexQuestionPoints1)),0))*100</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">-----------------------------------------------------------</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">vRollingMonthsGeneral is an expression to calculate rolling months:</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">[Survey Year]=,[Survey Month]=,[Survey Date]= ,[Survey Month Year]=,dimSurveyReceivedDateItself={">$(=monthend(AddMonths(Max(Date),-$(vNumRollinMonth))))<=$(=Max(Date))"}</SPAN></P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Then</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">I create a variable for this expression called vCSE and add the expression the table like this Rank(Total <Dealer Zone> $(vCSE)), but the result I get is NA.</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">I guess something I need to change in expression?</P></BODY></HTML> Mon, 12 Feb 2018 18:58:20 GMT deniscamh 2018-02-12T18:58:20Z Rank Function with Multiple dimensions https://community.qlik.com/t5/App-Development/Rank-Function-with-Multiple-dimensions/m-p/12209#M860 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I have Question about rank function.</P><P>I need create pivot table with 4 dimensions: National, Dealer Zone, Dealer District and Dealer. and one measure let say it is sum(sales), (in reality I have much complected measure)</P><P></P><P>Then I need to rank each Dealer's sale with every dimension. </P><P>For example if Dealer's 1 sales will be rank 50 in National Level; rank 20 in Zone level and rank 5 in District level.</P><P>Something like below.</P><P>Any suggestions?</P><P><IMG alt="Ranking.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/193179_Ranking.PNG" style="height: 239px; width: 620px;" /></P></BODY></HTML> Mon, 12 Feb 2018 18:35:47 GMT https://community.qlik.com/t5/App-Development/Rank-Function-with-Multiple-dimensions/m-p/12209#M860 deniscamh 2018-02-12T18:35:47Z Re: Rank Function with Multiple dimensions https://community.qlik.com/t5/App-Development/Rank-Function-with-Multiple-dimensions/m-p/12210#M861 <HTML><HEAD></HEAD><BODY><P>You may need to use Total with rank to get rank at dimension level.</P><P>Rank(Total<National>Sum(Sales)) should be considering National Dim for the rank, you can use Total<National,[Dealer Zone]> to rank at dealer level for each national value.</P></BODY></HTML> Mon, 12 Feb 2018 18:41:18 GMT https://community.qlik.com/t5/App-Development/Rank-Function-with-Multiple-dimensions/m-p/12210#M861 Digvijay_Singh 2018-02-12T18:41:18Z Re: Rank Function with Multiple dimensions https://community.qlik.com/t5/App-Development/Rank-Function-with-Multiple-dimensions/m-p/12211#M862 <HTML><HEAD></HEAD><BODY><P>Yes I tried that before but it does not work.</P><P>I think there is something to do with my expression.</P><P>Here is my expression:</P><P>(if(sum({<$(vRollingMonthsGeneral)>}(msrConvenienceIndexQuestionPoints1))>0,</P><P>sum({<$(vRollingMonthsGeneral)>}(msrConvenienceIndexIndexScore1))/</P><P>sum({<$(vRollingMonthsGeneral)>}(msrConvenienceIndexQuestionPoints1)),0)</P><P>+</P><P>if(sum({<$(vRollingMonthsGeneral)>}(msrTreatmentIndexQuestionPoints1))>0,</P><P>sum({<$(vRollingMonthsGeneral)>}(msrTreatmentIndexIndexScore1))/</P><P>sum({<$(vRollingMonthsGeneral)>}(msrTreatmentIndexQuestionPoints1)),0)</P><P>+</P><P>if(sum({<$(vRollingMonthsGeneral)>}(msrValueIndexQuestionPoints1))>0,</P><P>sum({<$(vRollingMonthsGeneral)>}(msrValueIndexIndexScore1))/</P><P>sum({<$(vRollingMonthsGeneral)>}(msrValueIndexQuestionPoints1)),0)</P><P>+</P><P>if(sum({<$(vRollingMonthsGeneral)>}(msrQualityIndexQuestionPoints1))>0,</P><P>sum({<$(vRollingMonthsGeneral)>}(msrQualityIndexIndexScore1))/</P><P>sum({<$(vRollingMonthsGeneral)>}(msrQualityIndexQuestionPoints1)),0))*100</P><P>-----------------------------------------------------------</P><P></P><P><SPAN style="font-size: 13.3333px;">vRollingMonthsGeneral is an expression to calculate rolling months:</SPAN></P><P><SPAN style="font-size: 13.3333px;">[Survey Year]=,[Survey Month]=,[Survey Date]= ,[Survey Month Year]=,dimSurveyReceivedDateItself={">$(=monthend(AddMonths(Max(Date),-$(vNumRollinMonth))))<=$(=Max(Date))"}</SPAN></P><P></P><P>Then</P><P>I create a variable for this expression called vCSE and add the expression the table like this Rank(Total <Dealer Zone> $(vCSE)), but the result I get is NA.</P><P>I guess something I need to change in expression?</P></BODY></HTML> Mon, 12 Feb 2018 18:52:53 GMT https://community.qlik.com/t5/App-Development/Rank-Function-with-Multiple-dimensions/m-p/12211#M862 deniscamh 2018-02-12T18:52:53Z Re: Rank Function with Multiple dimensions https://community.qlik.com/t5/App-Development/Rank-Function-with-Multiple-dimensions/m-p/12212#M863 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Yes I tried that before but it does not work.</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">I think there is something to do with my expression.</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Here is my expression:</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">(if(sum({<$(vRollingMonthsGeneral)>}(msrConvenienceIndexQuestionPoints1))>0,</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">sum({<$(vRollingMonthsGeneral)>}(msrConvenienceIndexIndexScore1))/</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">sum({<$(vRollingMonthsGeneral)>}(msrConvenienceIndexQuestionPoints1)),0)</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">+</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">if(sum({<$(vRollingMonthsGeneral)>}(msrTreatmentIndexQuestionPoints1))>0,</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">sum({<$(vRollingMonthsGeneral)>}(msrTreatmentIndexIndexScore1))/</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">sum({<$(vRollingMonthsGeneral)>}(msrTreatmentIndexQuestionPoints1)),0)</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">+</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">if(sum({<$(vRollingMonthsGeneral)>}(msrValueIndexQuestionPoints1))>0,</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">sum({<$(vRollingMonthsGeneral)>}(msrValueIndexIndexScore1))/</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">sum({<$(vRollingMonthsGeneral)>}(msrValueIndexQuestionPoints1)),0)</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">+</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">if(sum({<$(vRollingMonthsGeneral)>}(msrQualityIndexQuestionPoints1))>0,</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">sum({<$(vRollingMonthsGeneral)>}(msrQualityIndexIndexScore1))/</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">sum({<$(vRollingMonthsGeneral)>}(msrQualityIndexQuestionPoints1)),0))*100</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">-----------------------------------------------------------</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">vRollingMonthsGeneral is an expression to calculate rolling months:</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">[Survey Year]=,[Survey Month]=,[Survey Date]= ,[Survey Month Year]=,dimSurveyReceivedDateItself={">$(=monthend(AddMonths(Max(Date),-$(vNumRollinMonth))))<=$(=Max(Date))"}</SPAN></P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Then</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">I create a variable for this expression called vCSE and add the expression the table like this Rank(Total <Dealer Zone> $(vCSE)), but the result I get is NA.</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">I guess something I need to change in expression?</P></BODY></HTML> Mon, 12 Feb 2018 18:58:20 GMT https://community.qlik.com/t5/App-Development/Rank-Function-with-Multiple-dimensions/m-p/12212#M863 deniscamh 2018-02-12T18:58:20Z Re: Rank Function with Multiple dimensions https://community.qlik.com/t5/App-Development/Rank-Function-with-Multiple-dimensions/m-p/12213#M864 <HTML><HEAD></HEAD><BODY><P>Did you verify your expression? Hope it works before using it with Rank. Just trying to understand if all code pieces are working individually.</P></BODY></HTML> Mon, 12 Feb 2018 19:00:47 GMT https://community.qlik.com/t5/App-Development/Rank-Function-with-Multiple-dimensions/m-p/12213#M864 Digvijay_Singh 2018-02-12T19:00:47Z Re: Rank Function with Multiple dimensions https://community.qlik.com/t5/App-Development/Rank-Function-with-Multiple-dimensions/m-p/12214#M865 <HTML><HEAD></HEAD><BODY><P>Yes it works, and it also works when I do Rank(total $(vCSE)), but when I add <Dealer Zone> it does not work</P></BODY></HTML> Mon, 12 Feb 2018 19:02:54 GMT https://community.qlik.com/t5/App-Development/Rank-Function-with-Multiple-dimensions/m-p/12214#M865 deniscamh 2018-02-12T19:02:54Z Re: Rank Function with Multiple dimensions https://community.qlik.com/t5/App-Development/Rank-Function-with-Multiple-dimensions/m-p/12215#M866 <HTML><HEAD></HEAD><BODY><P>Hope you have used [] as the field has space in between.</P></BODY></HTML> Mon, 12 Feb 2018 19:06:09 GMT https://community.qlik.com/t5/App-Development/Rank-Function-with-Multiple-dimensions/m-p/12215#M866 Digvijay_Singh 2018-02-12T19:06:09Z Re: Rank Function with Multiple dimensions https://community.qlik.com/t5/App-Development/Rank-Function-with-Multiple-dimensions/m-p/12216#M867 <HTML><HEAD></HEAD><BODY><P>Yes I did <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P>Still does not work</P></BODY></HTML> Mon, 12 Feb 2018 19:08:20 GMT https://community.qlik.com/t5/App-Development/Rank-Function-with-Multiple-dimensions/m-p/12216#M867 deniscamh 2018-02-12T19:08:20Z Re: Rank Function with Multiple dimensions https://community.qlik.com/t5/App-Development/Rank-Function-with-Multiple-dimensions/m-p/12217#M868 <HTML><HEAD></HEAD><BODY><P>Can you share app to look further, or share the exact full expression which is not working, I see the field name you are referring in responses is still different than the one in image <IMG src="https://community.qlik.com/legacyfs/online/emoticons/confused.png" /></P></BODY></HTML> Mon, 12 Feb 2018 19:15:02 GMT https://community.qlik.com/t5/App-Development/Rank-Function-with-Multiple-dimensions/m-p/12217#M868 Digvijay_Singh 2018-02-12T19:15:02Z Re: Rank Function with Multiple dimensions https://community.qlik.com/t5/App-Development/Rank-Function-with-Multiple-dimensions/m-p/12218#M869 <HTML><HEAD></HEAD><BODY><P>Would it be possible for you to share a sample?</P></BODY></HTML> Mon, 12 Feb 2018 19:22:21 GMT https://community.qlik.com/t5/App-Development/Rank-Function-with-Multiple-dimensions/m-p/12218#M869 sunny_talwar 2018-02-12T19:22:21Z Re: Rank Function with Multiple dimensions https://community.qlik.com/t5/App-Development/Rank-Function-with-Multiple-dimensions/m-p/12219#M870 <HTML><HEAD></HEAD><BODY><P>please see the app aatached</P></BODY></HTML> Mon, 12 Feb 2018 19:26:06 GMT https://community.qlik.com/t5/App-Development/Rank-Function-with-Multiple-dimensions/m-p/12219#M870 deniscamh 2018-02-12T19:26:06Z Re: Rank Function with Multiple dimensions https://community.qlik.com/t5/App-Development/Rank-Function-with-Multiple-dimensions/m-p/12220#M871 <HTML><HEAD></HEAD><BODY><P>Hi Sanny,</P><P>Please see the attached.</P></BODY></HTML> Mon, 12 Feb 2018 19:28:35 GMT https://community.qlik.com/t5/App-Development/Rank-Function-with-Multiple-dimensions/m-p/12220#M871 deniscamh 2018-02-12T19:28:35Z Re: Rank Function with Multiple dimensions https://community.qlik.com/t5/App-Development/Rank-Function-with-Multiple-dimensions/m-p/12221#M872 <HTML><HEAD></HEAD><BODY><P>The pivot is showing null in dimension, may be due to extension in the left top having some special selections required, can you share how to populate data even without using the expression?</P></BODY></HTML> Mon, 12 Feb 2018 19:43:06 GMT https://community.qlik.com/t5/App-Development/Rank-Function-with-Multiple-dimensions/m-p/12221#M872 Digvijay_Singh 2018-02-12T19:43:06Z Re: Rank Function with Multiple dimensions https://community.qlik.com/t5/App-Development/Rank-Function-with-Multiple-dimensions/m-p/12222#M873 <HTML><HEAD></HEAD><BODY><P>The extension is used to  choose number of Months for this expression</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">vRollingMonthsGeneral:</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;">[Survey Year]=,[Survey Month]=,[Survey Date]= ,[Survey Month Year]=,dimSurveyReceivedDateItself={">$(=monthend(AddMonths(Max(Date),-$(vNumRollinMonth))))<=$(=Max(Date))"}</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-style: inherit; font-size: 13.3333px; font-family: inherit; font-weight: inherit;">You can find this </SPAN><SPAN style="color: #3d3d3d; font-size: 13.3333px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">variable</SPAN><SPAN style="color: #3d3d3d;"><SPAN style="font-style: inherit; font-size: 13.3333px; font-family: inherit; font-weight: inherit;"> in the </SPAN><SPAN style="font-size: 13.3333px;">variable</SPAN><SPAN style="font-style: inherit; font-size: 13.3333px; font-family: inherit; font-weight: inherit;"> section and change </SPAN></SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;">vNumRollinMonth to 3.</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;">Hope it make sense.</SPAN></P></BODY></HTML> Mon, 12 Feb 2018 19:49:53 GMT https://community.qlik.com/t5/App-Development/Rank-Function-with-Multiple-dimensions/m-p/12222#M873 deniscamh 2018-02-12T19:49:53Z Re: Rank Function with Multiple dimensions https://community.qlik.com/t5/App-Development/Rank-Function-with-Multiple-dimensions/m-p/12223#M874 <HTML><HEAD></HEAD><BODY><P>Do we need to make any other selections? It still shows '-' for the dimension</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/193190_Capture.PNG" style="height: 124px; width: 620px;" /></P></BODY></HTML> Mon, 12 Feb 2018 20:00:46 GMT https://community.qlik.com/t5/App-Development/Rank-Function-with-Multiple-dimensions/m-p/12223#M874 sunny_talwar 2018-02-12T20:00:46Z Re: Rank Function with Multiple dimensions https://community.qlik.com/t5/App-Development/Rank-Function-with-Multiple-dimensions/m-p/12224#M875 <HTML><HEAD></HEAD><BODY><P>In Adds on Select Include Zero values please.</P><P>The reason the data is not showing is because I loaded only first 500 rows and there probably no data for that calculation</P></BODY></HTML> Mon, 12 Feb 2018 20:10:14 GMT https://community.qlik.com/t5/App-Development/Rank-Function-with-Multiple-dimensions/m-p/12224#M875 deniscamh 2018-02-12T20:10:14Z Re: Rank Function with Multiple dimensions https://community.qlik.com/t5/App-Development/Rank-Function-with-Multiple-dimensions/m-p/12225#M876 <HTML><HEAD></HEAD><BODY><P>I only see the rows when add '=' in front of vCSEDealercode variable, but $(vCSEDealerCode) is showing 0 always.</P><P></P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/193193_Capture.PNG" style="height: 222px; width: 620px;" /></P></BODY></HTML> Mon, 12 Feb 2018 20:12:45 GMT https://community.qlik.com/t5/App-Development/Rank-Function-with-Multiple-dimensions/m-p/12225#M876 Digvijay_Singh 2018-02-12T20:12:45Z Re: Rank Function with Multiple dimensions https://community.qlik.com/t5/App-Development/Rank-Function-with-Multiple-dimensions/m-p/12226#M877 <HTML><HEAD></HEAD><BODY><P>I came up with somting like that aggr(rank($(vCSEDealerCode)),[Dealer Zone Code],[Dealer Code]) for zone</P><P>and aggr(rank($(vCSEDealerCode)),[Dealer Zone Code],[Dealer District Code], [Dealer Code]) for District.</P><P>but the problem is how I can ignore the filters now?</P></BODY></HTML> Mon, 12 Feb 2018 20:13:47 GMT https://community.qlik.com/t5/App-Development/Rank-Function-with-Multiple-dimensions/m-p/12226#M877 deniscamh 2018-02-12T20:13:47Z Re: Rank Function with Multiple dimensions https://community.qlik.com/t5/App-Development/Rank-Function-with-Multiple-dimensions/m-p/12227#M878 <HTML><HEAD></HEAD><BODY><P>It is probably because there is no data for a period I loaded. </P><P>I loaded only 500 rows in order to be able to share the app.</P><P>It is a huge app.</P><P>I was hoping by looking on the structure you can help me to figure out what's wrong.</P></BODY></HTML> Mon, 12 Feb 2018 20:19:12 GMT https://community.qlik.com/t5/App-Development/Rank-Function-with-Multiple-dimensions/m-p/12227#M878 deniscamh 2018-02-12T20:19:12Z Re: Rank Function with Multiple dimensions https://community.qlik.com/t5/App-Development/Rank-Function-with-Multiple-dimensions/m-p/12228#M879 <HTML><HEAD></HEAD><BODY><P>So I just used the aggr function for that and it worked:</P><P>for Rank National - aggr(rank($(vCSEAllNational)), [Dealer Code])</P><P>for Rank Zone - aggr(rank($(vCSEIndexZone)),[Dealer Zone Code],[Dealer Code])</P><P>for Rank District - aggr(rank($(vCSEDistrict)),[Dealer Zone Code],[Dealer District Code], [Dealer Code]).</P><P>And this is working fine.</P><P>The Total function inside Rank function does not work for some reason.</P><P>Thank you Sunny and Digvijay for your help.</P></BODY></HTML> Tue, 13 Feb 2018 14:41:44 GMT https://community.qlik.com/t5/App-Development/Rank-Function-with-Multiple-dimensions/m-p/12228#M879 deniscamh 2018-02-13T14:41:44Z