topic Re: How to rank using a piviot table in QlikView https://community.qlik.com/t5/QlikView/How-to-rank-using-a-piviot-table/m-p/257644#M498355 <HTML><HEAD></HEAD><BODY><P>You can use this as your reference.. see attached qvw..</P><P></P><P>Hope this will help you.. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/devil.png" /></P></BODY></HTML> Wed, 14 Sep 2011 07:59:24 GMT 2011-09-14T07:59:24Z How to rank using a piviot table https://community.qlik.com/t5/QlikView/How-to-rank-using-a-piviot-table/m-p/257639#M498350 <HTML><HEAD></HEAD><BODY><P>I have a pivot table which consists of sales offices and years.&nbsp; I need to rank a customer growth percentage for 2010 and compare it to 2011.&nbsp; I want to rank 2010 and compare the rank for 2011.&nbsp; Is there a simple way to do this?&nbsp; Here is the statement I am using.</P><P>Thanks</P><P></P><P></P><P>rank(count({$&lt;[Proposed Line Flag] = {'PL'}&gt;} DISTINCT ([Ship To])) / count(DISTINCT([Ship To]))</P></BODY></HTML> Tue, 13 Sep 2011 13:36:28 GMT https://community.qlik.com/t5/QlikView/How-to-rank-using-a-piviot-table/m-p/257639#M498350 tmumaw 2011-09-13T13:36:28Z How to rank using a piviot table https://community.qlik.com/t5/QlikView/How-to-rank-using-a-piviot-table/m-p/257640#M498351 <HTML><HEAD></HEAD><BODY><P>count({$&lt;[Proposed Line Flag] = {'PL'}&gt;} DISTINCT ([Ship To])) / count(DISTINCT([Ship To]) in first expression </P><P>and in second </P><P></P><P>rank(column(1))</P></BODY></HTML> Tue, 13 Sep 2011 14:42:29 GMT https://community.qlik.com/t5/QlikView/How-to-rank-using-a-piviot-table/m-p/257640#M498351 SunilChauhan 2011-09-13T14:42:29Z How to rank using a piviot table https://community.qlik.com/t5/QlikView/How-to-rank-using-a-piviot-table/m-p/257641#M498352 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Use some thing like </P><P></P><P>Rank( count({$&lt;[Proposed Line Flag] = {'PL'}&gt;} DISTINCT ([Ship To])) / count(DISTINCT([Ship To]),1 )</P><P></P><P></P><P>HTH</P><P></P><P>Regards</P><P>Anand</P></BODY></HTML> Tue, 13 Sep 2011 14:53:36 GMT https://community.qlik.com/t5/QlikView/How-to-rank-using-a-piviot-table/m-p/257641#M498352 its_anandrjs 2011-09-13T14:53:36Z Re: How to rank using a piviot table https://community.qlik.com/t5/QlikView/How-to-rank-using-a-piviot-table/m-p/257642#M498353 <HTML><HEAD></HEAD><BODY><P>What would cause the ranking to do this?&nbsp; Check out the PDF.</P></BODY></HTML> Tue, 13 Sep 2011 17:33:47 GMT https://community.qlik.com/t5/QlikView/How-to-rank-using-a-piviot-table/m-p/257642#M498353 tmumaw 2011-09-13T17:33:47Z Re: How to rank using a piviot table https://community.qlik.com/t5/QlikView/How-to-rank-using-a-piviot-table/m-p/257643#M498354 <HTML><HEAD></HEAD><BODY><P> What is the ,1 going to give me?</P></BODY></HTML> Tue, 13 Sep 2011 18:05:06 GMT https://community.qlik.com/t5/QlikView/How-to-rank-using-a-piviot-table/m-p/257643#M498354 tmumaw 2011-09-13T18:05:06Z Re: How to rank using a piviot table https://community.qlik.com/t5/QlikView/How-to-rank-using-a-piviot-table/m-p/257644#M498355 <HTML><HEAD></HEAD><BODY><P>You can use this as your reference.. see attached qvw..</P><P></P><P>Hope this will help you.. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/devil.png" /></P></BODY></HTML> Wed, 14 Sep 2011 07:59:24 GMT https://community.qlik.com/t5/QlikView/How-to-rank-using-a-piviot-table/m-p/257644#M498355 2011-09-14T07:59:24Z