topic Re: Re: Rank function not to consider OTHER and TOTAL in QlikView https://community.qlik.com/t5/QlikView/Rank-function-not-to-consider-OTHER-and-TOTAL/m-p/696648#M251667 <HTML><HEAD></HEAD><BODY><P>Is this you need?</P><P></P><P><IMG alt="p04.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/69700_p04.png" style="width: 620px; height: 337px;" /></P></BODY></HTML> Sat, 25 Oct 2014 15:46:39 GMT ecolomer 2014-10-25T15:46:39Z Rank function not to consider OTHER and TOTAL https://community.qlik.com/t5/QlikView/Rank-function-not-to-consider-OTHER-and-TOTAL/m-p/696640#M251659 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a straight chart table having rank function, but it is showing rank including OTHER and TOTAL as well. But I don't want to consider these two while ranking.</P><P></P><P>I just used Rank(Measure).</P><P></P><P>How to avoid OTHER and TOTAL?</P><P></P><P>Thanks,</P></BODY></HTML> Sat, 25 Oct 2014 08:01:23 GMT https://community.qlik.com/t5/QlikView/Rank-function-not-to-consider-OTHER-and-TOTAL/m-p/696640#M251659 2014-10-25T08:01:23Z Re: Rank function not to consider OTHER and TOTAL https://community.qlik.com/t5/QlikView/Rank-function-not-to-consider-OTHER-and-TOTAL/m-p/696641#M251660 <HTML><HEAD></HEAD><BODY><P>can you explain more or upload an simple data?</P></BODY></HTML> Sat, 25 Oct 2014 09:33:12 GMT https://community.qlik.com/t5/QlikView/Rank-function-not-to-consider-OTHER-and-TOTAL/m-p/696641#M251660 ecolomer 2014-10-25T09:33:12Z Re: Rank function not to consider OTHER and TOTAL https://community.qlik.com/t5/QlikView/Rank-function-not-to-consider-OTHER-and-TOTAL/m-p/696642#M251661 <HTML><HEAD></HEAD><BODY><P>include the data </P></BODY></HTML> Sat, 25 Oct 2014 10:01:23 GMT https://community.qlik.com/t5/QlikView/Rank-function-not-to-consider-OTHER-and-TOTAL/m-p/696642#M251661 2014-10-25T10:01:23Z Re: Rank function not to consider OTHER and TOTAL https://community.qlik.com/t5/QlikView/Rank-function-not-to-consider-OTHER-and-TOTAL/m-p/696643#M251662 <HTML><HEAD></HEAD><BODY><P>Can you please provide sample data &amp; Output needed for the same?</P></BODY></HTML> Sat, 25 Oct 2014 10:22:24 GMT https://community.qlik.com/t5/QlikView/Rank-function-not-to-consider-OTHER-and-TOTAL/m-p/696643#M251662 Kushal_Chawda 2014-10-25T10:22:24Z Re: Rank function not to consider OTHER and TOTAL https://community.qlik.com/t5/QlikView/Rank-function-not-to-consider-OTHER-and-TOTAL/m-p/696644#M251663 <HTML><HEAD></HEAD><BODY><P>no datafile</P></BODY></HTML> Sat, 25 Oct 2014 10:59:56 GMT https://community.qlik.com/t5/QlikView/Rank-function-not-to-consider-OTHER-and-TOTAL/m-p/696644#M251663 ecolomer 2014-10-25T10:59:56Z Re: Rank function not to consider OTHER and TOTAL https://community.qlik.com/t5/QlikView/Rank-function-not-to-consider-OTHER-and-TOTAL/m-p/696645#M251664 <HTML><HEAD></HEAD><BODY><P>Sorry for the delay as it is festive season in INDIA, here you go.</P><P></P><P>I am creating straight chart table with Weekdate,SUM(SoldAmt) and Rank(SUM(SoldAmt)). Dimension limit is 6 and I have enabled options Show Others and Totals, but Rank is displaying 1 for TOTAL and 2 for OTHER. Selected dates are 12/9/2013, 5/9/2014, 5/26/2014, 6/9/2014, 6/16/2014</P><P></P><P>I am using personal edition, please let me know if you need further details.</P><P></P><P>Thanks</P></BODY></HTML> Sat, 25 Oct 2014 15:13:52 GMT https://community.qlik.com/t5/QlikView/Rank-function-not-to-consider-OTHER-and-TOTAL/m-p/696645#M251664 2014-10-25T15:13:52Z Re: Rank function not to consider OTHER and TOTAL https://community.qlik.com/t5/QlikView/Rank-function-not-to-consider-OTHER-and-TOTAL/m-p/696646#M251665 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Can you upload an image of your table?</P></BODY></HTML> Sat, 25 Oct 2014 15:18:53 GMT https://community.qlik.com/t5/QlikView/Rank-function-not-to-consider-OTHER-and-TOTAL/m-p/696646#M251665 sorrakis01 2014-10-25T15:18:53Z Re: Re: Rank function not to consider OTHER and TOTAL https://community.qlik.com/t5/QlikView/Rank-function-not-to-consider-OTHER-and-TOTAL/m-p/696647#M251666 <HTML><HEAD></HEAD><BODY><P>Pls find the attached qvw file.</P><P></P><P>Thanks,</P></BODY></HTML> Sat, 25 Oct 2014 15:27:03 GMT https://community.qlik.com/t5/QlikView/Rank-function-not-to-consider-OTHER-and-TOTAL/m-p/696647#M251666 2014-10-25T15:27:03Z Re: Re: Rank function not to consider OTHER and TOTAL https://community.qlik.com/t5/QlikView/Rank-function-not-to-consider-OTHER-and-TOTAL/m-p/696648#M251667 <HTML><HEAD></HEAD><BODY><P>Is this you need?</P><P></P><P><IMG alt="p04.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/69700_p04.png" style="width: 620px; height: 337px;" /></P></BODY></HTML> Sat, 25 Oct 2014 15:46:39 GMT https://community.qlik.com/t5/QlikView/Rank-function-not-to-consider-OTHER-and-TOTAL/m-p/696648#M251667 ecolomer 2014-10-25T15:46:39Z Re: Re: Rank function not to consider OTHER and TOTAL https://community.qlik.com/t5/QlikView/Rank-function-not-to-consider-OTHER-and-TOTAL/m-p/696649#M251668 <HTML><HEAD></HEAD><BODY><P>If you can't open my file, the expression is:</P><P></P><P><STRONG>=IF(Aggr(Rank(SUM(SoldAmt),4),WeekDate)&lt;=5,WeekDate)</STRONG></P></BODY></HTML> Sat, 25 Oct 2014 15:47:52 GMT https://community.qlik.com/t5/QlikView/Rank-function-not-to-consider-OTHER-and-TOTAL/m-p/696649#M251668 ecolomer 2014-10-25T15:47:52Z Re: Re: Re: Rank function not to consider OTHER and TOTAL https://community.qlik.com/t5/QlikView/Rank-function-not-to-consider-OTHER-and-TOTAL/m-p/696650#M251669 <HTML><HEAD></HEAD><BODY><P>Please find the attached one.</P><P></P><P>Is it what you are looking for? !</P></BODY></HTML> Sat, 25 Oct 2014 18:58:42 GMT https://community.qlik.com/t5/QlikView/Rank-function-not-to-consider-OTHER-and-TOTAL/m-p/696650#M251669 Kushal_Chawda 2014-10-25T18:58:42Z Re: Re: Rank function not to consider OTHER and TOTAL https://community.qlik.com/t5/QlikView/Rank-function-not-to-consider-OTHER-and-TOTAL/m-p/696651#M251670 <HTML><HEAD></HEAD><BODY><P>I want both OTHER and TOTAL should be displayed without considering rank. Rank should apply only for weekdate and SoldAmt, shouldn't consider OTHER and TOTAL.</P><P></P><P>Thanks,</P></BODY></HTML> Sat, 25 Oct 2014 19:08:11 GMT https://community.qlik.com/t5/QlikView/Rank-function-not-to-consider-OTHER-and-TOTAL/m-p/696651#M251670 2014-10-25T19:08:11Z Re: Re: Rank function not to consider OTHER and TOTAL https://community.qlik.com/t5/QlikView/Rank-function-not-to-consider-OTHER-and-TOTAL/m-p/696652#M251671 <HTML><HEAD></HEAD><BODY><P>Dear Madu,</P><P>Please look into the solution that I have attached before</P></BODY></HTML> Sun, 26 Oct 2014 05:15:25 GMT https://community.qlik.com/t5/QlikView/Rank-function-not-to-consider-OTHER-and-TOTAL/m-p/696652#M251671 Kushal_Chawda 2014-10-26T05:15:25Z Re: Re: Re: Rank function not to consider OTHER and TOTAL https://community.qlik.com/t5/QlikView/Rank-function-not-to-consider-OTHER-and-TOTAL/m-p/696653#M251672 <HTML><HEAD></HEAD><BODY><P>OK, This?</P><P></P><P><IMG alt="p05.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/69707_p05.png" style="width: 620px; height: 290px;" /></P></BODY></HTML> Sun, 26 Oct 2014 05:49:00 GMT https://community.qlik.com/t5/QlikView/Rank-function-not-to-consider-OTHER-and-TOTAL/m-p/696653#M251672 ecolomer 2014-10-26T05:49:00Z Re: Rank function not to consider OTHER and TOTAL https://community.qlik.com/t5/QlikView/Rank-function-not-to-consider-OTHER-and-TOTAL/m-p/696654#M251673 <HTML><HEAD></HEAD><BODY><P>I am using personal edition, not able to open.</P><P></P><P>Thanks,</P></BODY></HTML> Sun, 26 Oct 2014 13:53:32 GMT https://community.qlik.com/t5/QlikView/Rank-function-not-to-consider-OTHER-and-TOTAL/m-p/696654#M251673 2014-10-26T13:53:32Z Re: Rank function not to consider OTHER and TOTAL https://community.qlik.com/t5/QlikView/Rank-function-not-to-consider-OTHER-and-TOTAL/m-p/696655#M251674 <HTML><HEAD></HEAD><BODY><P>Please follow the below steps</P><P></P><P>1) Take a dimension as WeekDate</P><P>2) Do the settings in Dimension limit tab as required</P><P>3) Take 1st Expression as <STRONG>Sum(SoldAmt)</STRONG></P><P>4) Take 2nd Expression as <STRONG>aggr(rank(sum(SoldAmt),4),WeekDate)</STRONG></P><P>5) Sort Chart by 2nd Expression</P></BODY></HTML> Sun, 26 Oct 2014 14:25:25 GMT https://community.qlik.com/t5/QlikView/Rank-function-not-to-consider-OTHER-and-TOTAL/m-p/696655#M251674 Kushal_Chawda 2014-10-26T14:25:25Z Re: Rank function not to consider OTHER and TOTAL https://community.qlik.com/t5/QlikView/Rank-function-not-to-consider-OTHER-and-TOTAL/m-p/696656#M251675 <HTML><HEAD></HEAD><BODY><P>Here you have an image</P><P><IMG alt="p06.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/69708_p06.png" style="width: 620px; height: 249px;" /></P><P>You can see it?</P></BODY></HTML> Sun, 26 Oct 2014 14:42:44 GMT https://community.qlik.com/t5/QlikView/Rank-function-not-to-consider-OTHER-and-TOTAL/m-p/696656#M251675 ecolomer 2014-10-26T14:42:44Z