topic Help with rank function please in QlikView https://community.qlik.com/t5/QlikView/Help-with-rank-function-please/m-p/255800#M96815 <HTML><HEAD></HEAD><BODY><P>Bump!</P><P></P><P>Appreciate if someone can point me in a right direction to fix this...</P></BODY></HTML> Mon, 28 Nov 2011 14:48:33 GMT 2011-11-28T14:48:33Z Help with rank function please https://community.qlik.com/t5/QlikView/Help-with-rank-function-please/m-p/255799#M96814 <HTML><HEAD></HEAD><BODY><P>I want to prepare a chart with different ranks for one selected client (CMU2_NM)</P><P></P><P>CMU2_NM is not part of dimension. Chart dimension is - CALENDAR_PERIOD since the ranks are needed for different periods. 4 possible values for CALENDAR_PERIOD are loaded using inline load.</P><P></P><P>Added below expression for the chart -</P><P></P><P>=if(CALENDAR_PERIOD='YTD 2011',</P><P>Aggr(rank(sum({&lt;CMU2_NM={"*"}&gt;}F_CV_YTD)),CMU2_NM), </P><P>if(CALENDAR_PERIOD='YTD 2010', </P><P>Aggr(rank(sum({&lt;CMU2_NM={"*"}&gt;}F_CV_PREV_YTD)),CMU2_NM)))</P><P></P><P></P><P>Now the problem is only first rank YTD 2011 is displayed... other ranks are not displayed and instead it shows "-". Please refer to attached image..</P><P></P><P>Can someone help please to fix above expression... </P><P></P><P></P><P></P></BODY></HTML> Fri, 25 Nov 2011 10:03:31 GMT https://community.qlik.com/t5/QlikView/Help-with-rank-function-please/m-p/255799#M96814 2011-11-25T10:03:31Z Help with rank function please https://community.qlik.com/t5/QlikView/Help-with-rank-function-please/m-p/255800#M96815 <HTML><HEAD></HEAD><BODY><P>Bump!</P><P></P><P>Appreciate if someone can point me in a right direction to fix this...</P></BODY></HTML> Mon, 28 Nov 2011 14:48:33 GMT https://community.qlik.com/t5/QlikView/Help-with-rank-function-please/m-p/255800#M96815 2011-11-28T14:48:33Z