topic Rank function in QlikView https://community.qlik.com/t5/QlikView/Rank-function/m-p/295598#M109705 <HTML><HEAD></HEAD><BODY><P style="background-color: #eef4f9; font-size: 12px; color: #636363; font-family: Arial;">help combining Rank function, Modes for Cutomers and a Mix?</P></BODY></HTML> Sat, 21 Jan 2012 07:57:32 GMT 2012-01-21T07:57:32Z Rank function https://community.qlik.com/t5/QlikView/Rank-function/m-p/295598#M109705 <HTML><HEAD></HEAD><BODY><P style="background-color: #eef4f9; font-size: 12px; color: #636363; font-family: Arial;">help combining Rank function, Modes for Cutomers and a Mix?</P></BODY></HTML> Sat, 21 Jan 2012 07:57:32 GMT https://community.qlik.com/t5/QlikView/Rank-function/m-p/295598#M109705 2012-01-21T07:57:32Z top 5 Model mix by top 5 by customer, cant get aggr function to work https://community.qlik.com/t5/QlikView/Rank-function/m-p/295599#M109706 <HTML><HEAD></HEAD><BODY><P>Hi Joseph</P><P></P><P>You need 3 dimensions : </P><P>YEAR</P><P>=If(&nbsp;&nbsp; Aggr(&nbsp;&nbsp;&nbsp; Rank(&nbsp;&nbsp; sum(SALES)) , YEAR , MIX )&nbsp; &lt;=5 , MIX)&nbsp;&nbsp; /*&nbsp; TOP 5 MIX BY YEAR */</P><P>=If(&nbsp;&nbsp; Aggr(&nbsp;&nbsp;&nbsp; Rank(&nbsp;&nbsp; sum(SALES)) , YEAR , MIX&nbsp; , CUSTOMER)&nbsp; &lt;=5 , CUSTOMER)&nbsp; /* TOP 5 CUSTOMER BY YEAR &amp; MIX */</P><P></P><P>Regards</P><P>JJ</P></BODY></HTML> Sat, 21 Jan 2012 08:19:34 GMT https://community.qlik.com/t5/QlikView/Rank-function/m-p/295599#M109706 2012-01-21T08:19:34Z