topic Re: Rank function in QlikView https://community.qlik.com/t5/QlikView/Rank-function/m-p/769744#M273299 <HTML><HEAD></HEAD><BODY><P>Rank function can only(directly) be used in chart expression. However, you can try alternatively like:</P><P>=Aggr(Rank(Sum({1} Amount)), Dimension)</P><P></P><P>PFA</P></BODY></HTML> Mon, 23 Feb 2015 10:53:27 GMT tresB 2015-02-23T10:53:27Z Rank function https://community.qlik.com/t5/QlikView/Rank-function/m-p/769743#M273298 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P>Need your help with Rank().When I am applying rank() in grid its giving me correct rank but when i am using it in text box for selected geography its giving rank as 1 for each value.Please suggest your opinions.</P><P>Thanks!</P></BODY></HTML> Mon, 23 Feb 2015 10:36:30 GMT https://community.qlik.com/t5/QlikView/Rank-function/m-p/769743#M273298 vijetas42 2015-02-23T10:36:30Z Re: Rank function https://community.qlik.com/t5/QlikView/Rank-function/m-p/769744#M273299 <HTML><HEAD></HEAD><BODY><P>Rank function can only(directly) be used in chart expression. However, you can try alternatively like:</P><P>=Aggr(Rank(Sum({1} Amount)), Dimension)</P><P></P><P>PFA</P></BODY></HTML> Mon, 23 Feb 2015 10:53:27 GMT https://community.qlik.com/t5/QlikView/Rank-function/m-p/769744#M273299 tresB 2015-02-23T10:53:27Z