topic Re: How to use rank, aggr? in QlikView https://community.qlik.com/t5/QlikView/How-to-use-rank-aggr/m-p/877677#M306466 <HTML><HEAD></HEAD><BODY><P>Not sure how you are getting those results?? Would you be able to give a excel document which shows how the average numbers are calculated?</P><P></P><P>Best,</P><P>Sunny</P></BODY></HTML> Thu, 11 Jun 2015 20:49:16 GMT sunny_talwar 2015-06-11T20:49:16Z How to use rank, aggr? https://community.qlik.com/t5/QlikView/How-to-use-rank-aggr/m-p/877676#M306465 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I'm not sure how to get my chart to show the following</P><P style="font-size: 13.3333330154419px;"><STRONG>Country&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Avr</STRONG></P><P style="font-size: 13.3333330154419px;">US&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 19,33</P><P style="font-size: 13.3333330154419px;">FR&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 14</P><P style="font-size: 13.3333330154419px;"><SPAN style="font-size: 13.3333330154419px; line-height: 1.5em;"><BR /></SPAN></P><P style="font-size: 13.3333330154419px;"><SPAN style="font-size: 13.3333330154419px; line-height: 1.5em;">The average value is the average of the top 3 value for each Person</SPAN></P><P></P><P>Data:</P><P>Country Person Value</P><P>Us&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13</P><P>Us&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12</P><P>Us&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 14</P><P>Us&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12</P><P>Us&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15&nbsp;&nbsp;&nbsp;&nbsp; </P><P>Us&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; b&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12</P><P>Us&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; b&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11</P><P>Us&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; b&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 14&nbsp;&nbsp;&nbsp;&nbsp; </P><P>Us&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; c&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12</P><P>Us&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; c&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11</P><P>FR&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; c&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 14&nbsp;&nbsp;&nbsp;&nbsp; </P><P>FR&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; f&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13</P><P>FR&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; f&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13</P><P>FR&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; f&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13&nbsp;&nbsp;&nbsp;&nbsp; </P><P>FR&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; a&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15</P><P>FR&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; a&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15</P><P>FR&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; a&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15&nbsp; </P><P>FR&nbsp;&nbsp;&nbsp;&nbsp; a&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12&nbsp; </P></BODY></HTML> Thu, 11 Jun 2015 19:27:39 GMT https://community.qlik.com/t5/QlikView/How-to-use-rank-aggr/m-p/877676#M306465 2015-06-11T19:27:39Z Re: How to use rank, aggr? https://community.qlik.com/t5/QlikView/How-to-use-rank-aggr/m-p/877677#M306466 <HTML><HEAD></HEAD><BODY><P>Not sure how you are getting those results?? Would you be able to give a excel document which shows how the average numbers are calculated?</P><P></P><P>Best,</P><P>Sunny</P></BODY></HTML> Thu, 11 Jun 2015 20:49:16 GMT https://community.qlik.com/t5/QlikView/How-to-use-rank-aggr/m-p/877677#M306466 sunny_talwar 2015-06-11T20:49:16Z Re: How to use rank, aggr? https://community.qlik.com/t5/QlikView/How-to-use-rank-aggr/m-p/877678#M306467 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>First of all thank's for taking the time to help. I do understand why you did not understand the calculation I made a mistake when i did my example.</P><P></P><P>I have no excel on the computer I' on now but made an example on google sheets. Hope you can read that one</P><P></P><P><A href="https://docs.google.com/spreadsheets/d/13s-6VX7E5MCt3Sh7Mu4__1xk2KNimgh4oi4uEBbSqUs/edit?usp=sharing" title="https://docs.google.com/spreadsheets/d/13s-6VX7E5MCt3Sh7Mu4__1xk2KNimgh4oi4uEBbSqUs/edit?usp=sharing">QV-EX - Google Sheets</A></P></BODY></HTML> Thu, 11 Jun 2015 21:13:39 GMT https://community.qlik.com/t5/QlikView/How-to-use-rank-aggr/m-p/877678#M306467 2015-06-11T21:13:39Z Re: How to use rank, aggr? https://community.qlik.com/t5/QlikView/How-to-use-rank-aggr/m-p/877679#M306468 <HTML><HEAD></HEAD><BODY><P>it would be easier done at script level by adding a sequence number/</P></BODY></HTML> Thu, 11 Jun 2015 22:33:31 GMT https://community.qlik.com/t5/QlikView/How-to-use-rank-aggr/m-p/877679#M306468 ramoncova06 2015-06-11T22:33:31Z Re: How to use rank, aggr? https://community.qlik.com/t5/QlikView/How-to-use-rank-aggr/m-p/877680#M306469 <HTML><HEAD></HEAD><BODY><P>I can't see how any calculation of average for US can be over 19 when the max US value for a person is only 15.</P><P>Agree with Sunny, the logic of the calculation should be provided...</P></BODY></HTML> Fri, 12 Jun 2015 01:24:56 GMT https://community.qlik.com/t5/QlikView/How-to-use-rank-aggr/m-p/877680#M306469 Anonymous 2015-06-12T01:24:56Z Re: How to use rank, aggr? https://community.qlik.com/t5/QlikView/How-to-use-rank-aggr/m-p/877681#M306470 <HTML><HEAD></HEAD><BODY><P>=aggr(if(rank(sum(value)&gt;=3,person),person)</P></BODY></HTML> Fri, 12 Jun 2015 05:44:22 GMT https://community.qlik.com/t5/QlikView/How-to-use-rank-aggr/m-p/877681#M306470 pratap6699 2015-06-12T05:44:22Z Re: How to use rank, aggr? https://community.qlik.com/t5/QlikView/How-to-use-rank-aggr/m-p/877682#M306471 <HTML><HEAD></HEAD><BODY><P>I think you can do this way</P></BODY></HTML> Fri, 12 Jun 2015 07:20:56 GMT https://community.qlik.com/t5/QlikView/How-to-use-rank-aggr/m-p/877682#M306471 Kushal_Chawda 2015-06-12T07:20:56Z Re: How to use rank, aggr? https://community.qlik.com/t5/QlikView/How-to-use-rank-aggr/m-p/877683#M306472 <HTML><HEAD></HEAD><BODY><P>Thank's for all the help solved it in the graph with the suggestion above.</P></BODY></HTML> Fri, 12 Jun 2015 17:09:04 GMT https://community.qlik.com/t5/QlikView/How-to-use-rank-aggr/m-p/877683#M306472 2015-06-12T17:09:04Z