topic Ranking Data in Tables in QlikView https://community.qlik.com/t5/QlikView/Ranking-Data-in-Tables/m-p/243975#M586359 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: tahoma,arial,helvetica,sans-serif;"><STRONG> </STRONG></SPAN></P><P><SPAN style="font-family: tahoma,arial,helvetica,sans-serif;"><STRONG>Hi everybody,</STRONG></SPAN></P><P></P><P><SPAN style="font-family: tahoma,arial,helvetica,sans-serif;">I have a question about ranking some data. I have every purchase from each client in my database, and I also have a column that tells me where (Store_ID) each customer made this purchase.</SPAN></P><P></P><P><SPAN style="font-family: tahoma,arial,helvetica,sans-serif;">What I need is making a Ranking, by Store, that indicates wich position each customer has in each store (1st buyer, 2nd buyer, etc).</SPAN></P><P><SPAN style="font-family: tahoma,arial,helvetica,sans-serif;"> </SPAN></P><P><SPAN style="font-family: tahoma,arial,helvetica,sans-serif;">I made an example in Excel spreadsheet attached, to make it clear.</SPAN></P><P><SPAN style="font-family: tahoma,arial,helvetica,sans-serif;"> </SPAN></P><P><SPAN style="font-family: tahoma,arial,helvetica,sans-serif;">If you can help me with this issue, would be great.</SPAN></P><P><SPAN style="font-family: tahoma,arial,helvetica,sans-serif;"> </SPAN></P><P><SPAN style="font-family: tahoma,arial,helvetica,sans-serif;">Thanx.</SPAN></P><P><SPAN style="font-family: tahoma,arial,helvetica,sans-serif;"> </SPAN></P><P><STRONG style="font-family: tahoma,arial,helvetica,sans-serif;">Rodrigo</STRONG></P></BODY></HTML> Tue, 02 Aug 2011 23:23:00 GMT 2011-08-02T23:23:00Z Ranking Data in Tables https://community.qlik.com/t5/QlikView/Ranking-Data-in-Tables/m-p/243975#M586359 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: tahoma,arial,helvetica,sans-serif;"><STRONG> </STRONG></SPAN></P><P><SPAN style="font-family: tahoma,arial,helvetica,sans-serif;"><STRONG>Hi everybody,</STRONG></SPAN></P><P></P><P><SPAN style="font-family: tahoma,arial,helvetica,sans-serif;">I have a question about ranking some data. I have every purchase from each client in my database, and I also have a column that tells me where (Store_ID) each customer made this purchase.</SPAN></P><P></P><P><SPAN style="font-family: tahoma,arial,helvetica,sans-serif;">What I need is making a Ranking, by Store, that indicates wich position each customer has in each store (1st buyer, 2nd buyer, etc).</SPAN></P><P><SPAN style="font-family: tahoma,arial,helvetica,sans-serif;"> </SPAN></P><P><SPAN style="font-family: tahoma,arial,helvetica,sans-serif;">I made an example in Excel spreadsheet attached, to make it clear.</SPAN></P><P><SPAN style="font-family: tahoma,arial,helvetica,sans-serif;"> </SPAN></P><P><SPAN style="font-family: tahoma,arial,helvetica,sans-serif;">If you can help me with this issue, would be great.</SPAN></P><P><SPAN style="font-family: tahoma,arial,helvetica,sans-serif;"> </SPAN></P><P><SPAN style="font-family: tahoma,arial,helvetica,sans-serif;">Thanx.</SPAN></P><P><SPAN style="font-family: tahoma,arial,helvetica,sans-serif;"> </SPAN></P><P><STRONG style="font-family: tahoma,arial,helvetica,sans-serif;">Rodrigo</STRONG></P></BODY></HTML> Tue, 02 Aug 2011 23:23:00 GMT https://community.qlik.com/t5/QlikView/Ranking-Data-in-Tables/m-p/243975#M586359 2011-08-02T23:23:00Z Re: Ranking Data in Tables https://community.qlik.com/t5/QlikView/Ranking-Data-in-Tables/m-p/243976#M586360 <HTML><HEAD></HEAD><BODY><P><EM>Hi Rodirigo,</EM></P><P><EM> </EM></P><P><EM>You could do this with the help of <STRONG>HRank(). </STRONG>You Expression would be as follows.</EM></P><P><EM> </EM></P><P><STRONG><EM>Hrank(sum(Data),0,1)</EM></STRONG></P><P><EM> </EM></P><P><EM>Check the attached application.</EM></P><P><EM> </EM></P><P><EM>- Sridhar</EM></P></BODY></HTML> Wed, 03 Aug 2011 03:10:01 GMT https://community.qlik.com/t5/QlikView/Ranking-Data-in-Tables/m-p/243976#M586360 2011-08-03T03:10:01Z Re: Ranking Data in Tables https://community.qlik.com/t5/QlikView/Ranking-Data-in-Tables/m-p/243977#M586361 <HTML><HEAD></HEAD><BODY><P>Thank you very much Sridhar, worked perfectly!</P><P></P><P>See ya...</P></BODY></HTML> Wed, 03 Aug 2011 21:02:10 GMT https://community.qlik.com/t5/QlikView/Ranking-Data-in-Tables/m-p/243977#M586361 2011-08-03T21:02:10Z