topic Ranking and Individual Reporting in QlikView https://community.qlik.com/t5/QlikView/Ranking-and-Individual-Reporting/m-p/545187#M203617 <HTML><HEAD></HEAD><BODY><P>Hi Everyone</P><P></P><P>I'm looking for a few pointers on something I'm a little stuck on.</P><P></P><P>Essentially I have a bunch of sales people ranked (using the rank function) on a chart top to bottom. What I want to do is create an "individual report" on the same app that will show an individual persons sales performance, reporting what their current rank is.</P><P></P><P>The problem I have is to run the individual report you select one salesperson. Of course when you do due to qliks associative model&nbsp; only their own data is being calculated, I therefore lose how they were ranked against the others (i.e. The salesperson I select would effectively be ranked 1 as there is no other data there).</P><P></P><P>Can anyone recommend a good approach - I think I might be able to do something with either set analysis or perhaps a variable, but I'm not really sure where to start.</P><P></P><P>Any help appreciated.</P><P>Thanks</P><P>Stu</P></BODY></HTML> Tue, 19 Nov 2013 15:13:02 GMT stuwannop 2013-11-19T15:13:02Z Ranking and Individual Reporting https://community.qlik.com/t5/QlikView/Ranking-and-Individual-Reporting/m-p/545187#M203617 <HTML><HEAD></HEAD><BODY><P>Hi Everyone</P><P></P><P>I'm looking for a few pointers on something I'm a little stuck on.</P><P></P><P>Essentially I have a bunch of sales people ranked (using the rank function) on a chart top to bottom. What I want to do is create an "individual report" on the same app that will show an individual persons sales performance, reporting what their current rank is.</P><P></P><P>The problem I have is to run the individual report you select one salesperson. Of course when you do due to qliks associative model&nbsp; only their own data is being calculated, I therefore lose how they were ranked against the others (i.e. The salesperson I select would effectively be ranked 1 as there is no other data there).</P><P></P><P>Can anyone recommend a good approach - I think I might be able to do something with either set analysis or perhaps a variable, but I'm not really sure where to start.</P><P></P><P>Any help appreciated.</P><P>Thanks</P><P>Stu</P></BODY></HTML> Tue, 19 Nov 2013 15:13:02 GMT https://community.qlik.com/t5/QlikView/Ranking-and-Individual-Reporting/m-p/545187#M203617 stuwannop 2013-11-19T15:13:02Z Re: Ranking and Individual Reporting https://community.qlik.com/t5/QlikView/Ranking-and-Individual-Reporting/m-p/545188#M203618 <HTML><HEAD></HEAD><BODY><P>If you create and calculate their rank in a field in the load script, you will have the value available at all times.</P></BODY></HTML> Tue, 19 Nov 2013 15:20:40 GMT https://community.qlik.com/t5/QlikView/Ranking-and-Individual-Reporting/m-p/545188#M203618 Nicole-Smith 2013-11-19T15:20:40Z