topic Re: Rank, aggr? in QlikView https://community.qlik.com/t5/QlikView/Rank-aggr/m-p/296667#M110029 <HTML><HEAD></HEAD><BODY><P>Two calculated dimensions.</P><P></P><P style="padding-left: 30px;"><SPAN style="font-family: courier new,courier;">=aggr(if(rank(Random)&nbsp;&nbsp; &lt;=3,Person_ID),Person_ID)</SPAN><BR /><SPAN style="font-family: courier new,courier;">=aggr(if(rank(Timestamp)&lt;=5,Timestamp),Person_ID,Timestamp)</SPAN></P><P></P><P>See attached.</P></BODY></HTML> Fri, 13 May 2011 22:15:45 GMT johnw 2011-05-13T22:15:45Z Rank, aggr? https://community.qlik.com/t5/QlikView/Rank-aggr/m-p/296666#M110028 <HTML><HEAD></HEAD><BODY><P>I have one table there are the person_IDs and timestamps stored. I have created a new table there I give for every single person_ID a random number.</P><P>For my result I want to have an pivottable with the 3 person_IDs that has highest random number and for evey person_ID only 5 highest timestamps. </P><P></P><P>I attach the excel-file with example-data to illustrate it.</P><P></P><P>I hope someone could help me...</P><P></P><P>Liivi</P></BODY></HTML> Fri, 13 May 2011 05:46:08 GMT https://community.qlik.com/t5/QlikView/Rank-aggr/m-p/296666#M110028 2011-05-13T05:46:08Z Re: Rank, aggr? https://community.qlik.com/t5/QlikView/Rank-aggr/m-p/296667#M110029 <HTML><HEAD></HEAD><BODY><P>Two calculated dimensions.</P><P></P><P style="padding-left: 30px;"><SPAN style="font-family: courier new,courier;">=aggr(if(rank(Random)&nbsp;&nbsp; &lt;=3,Person_ID),Person_ID)</SPAN><BR /><SPAN style="font-family: courier new,courier;">=aggr(if(rank(Timestamp)&lt;=5,Timestamp),Person_ID,Timestamp)</SPAN></P><P></P><P>See attached.</P></BODY></HTML> Fri, 13 May 2011 22:15:45 GMT https://community.qlik.com/t5/QlikView/Rank-aggr/m-p/296667#M110029 johnw 2011-05-13T22:15:45Z Rank, aggr? https://community.qlik.com/t5/QlikView/Rank-aggr/m-p/296668#M110030 <HTML><HEAD></HEAD><BODY><P> Thanx a lot!! It worked fine <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P></P><P>Liivi</P></BODY></HTML> Mon, 16 May 2011 12:39:15 GMT https://community.qlik.com/t5/QlikView/Rank-aggr/m-p/296668#M110030 2011-05-16T12:39:15Z