topic Re: Rank function by Time? in QlikView https://community.qlik.com/t5/QlikView/Rank-function-by-Time/m-p/450792#M1153199 <HTML><HEAD></HEAD><BODY><P>THANKS swuehi - really appreciate the speedy help!</P></BODY></HTML> Sat, 11 May 2013 22:24:14 GMT 2013-05-11T22:24:14Z Rank function by Time? https://community.qlik.com/t5/QlikView/Rank-function-by-Time/m-p/450790#M1153197 <HTML><HEAD></HEAD><BODY><P>Trying to get a aggr, rank expression to work over a time field within a Parent, Child and 3rd dimension, either Type or Group.</P><P></P><P>I've attached a Rank_Test.qvw, and a screenshot. The first aggr(rank( expression works (with the exception that it's ranking them in reverse order?), but I can't get it to rank over the the third dimension -&gt; Type or Group. It ranks the first of each Type, and the first of each Group. So if there is a 3 Type1, and 2 Type 2 and 3 Type 3. It will rank the 1st Type1, the 1st Type2 and the first Type3. But I want it to rank the 3 Type1, and rank the 2 Type3 and the 3 Type3 independently. ie., Give the 3 Type1's each a 1, 2 and 3 rank, then rank the 2 Type2 as 1 and 2, and then rank the 3 Type3 as 1, 2 and 3. And do the same thing for Group.</P></BODY></HTML> Sat, 11 May 2013 20:12:42 GMT https://community.qlik.com/t5/QlikView/Rank-function-by-Time/m-p/450790#M1153197 2013-05-11T20:12:42Z Re: Rank function by Time? https://community.qlik.com/t5/QlikView/Rank-function-by-Time/m-p/450791#M1153198 <HTML><HEAD></HEAD><BODY><P>Maybe like this?</P></BODY></HTML> Sat, 11 May 2013 21:22:58 GMT https://community.qlik.com/t5/QlikView/Rank-function-by-Time/m-p/450791#M1153198 swuehl 2013-05-11T21:22:58Z Re: Rank function by Time? https://community.qlik.com/t5/QlikView/Rank-function-by-Time/m-p/450792#M1153199 <HTML><HEAD></HEAD><BODY><P>THANKS swuehi - really appreciate the speedy help!</P></BODY></HTML> Sat, 11 May 2013 22:24:14 GMT https://community.qlik.com/t5/QlikView/Rank-function-by-Time/m-p/450792#M1153199 2013-05-11T22:24:14Z