topic Re: Rank function with multiple dimensions in QlikView https://community.qlik.com/t5/QlikView/Rank-function-with-multiple-dimensions/m-p/775588#M1045209 <HTML><HEAD></HEAD><BODY><P>=rank(total sum(Sales))</P></BODY></HTML> Wed, 19 Nov 2014 09:39:19 GMT anbu1984 2014-11-19T09:39:19Z Rank function with multiple dimensions https://community.qlik.com/t5/QlikView/Rank-function-with-multiple-dimensions/m-p/775587#M1045208 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I need a little help with the Rank function. </P><P>I have a chart with Dimensions Owner and Store, and Expression Sum (Sales). I would like to add an expression that ranks the stores sales against all stores, NOT just those within the same owner. I have attached the QVW as well as an XL file of what I'm trying to achieve.</P><P></P><P>Thanks in advance</P><P></P><P>W</P></BODY></HTML> Wed, 19 Nov 2014 09:37:17 GMT https://community.qlik.com/t5/QlikView/Rank-function-with-multiple-dimensions/m-p/775587#M1045208 warrenpress 2014-11-19T09:37:17Z Re: Rank function with multiple dimensions https://community.qlik.com/t5/QlikView/Rank-function-with-multiple-dimensions/m-p/775588#M1045209 <HTML><HEAD></HEAD><BODY><P>=rank(total sum(Sales))</P></BODY></HTML> Wed, 19 Nov 2014 09:39:19 GMT https://community.qlik.com/t5/QlikView/Rank-function-with-multiple-dimensions/m-p/775588#M1045209 anbu1984 2014-11-19T09:39:19Z Re: Rank function with multiple dimensions https://community.qlik.com/t5/QlikView/Rank-function-with-multiple-dimensions/m-p/775589#M1045210 <HTML><HEAD></HEAD><BODY><P>Hi Warren,</P><P></P><P>Just add in the TOTAL qualifier, so your expression would be =rank(TOTAL Sum(Sales)).</P><P></P><P>Thanks</P></BODY></HTML> Wed, 19 Nov 2014 09:39:32 GMT https://community.qlik.com/t5/QlikView/Rank-function-with-multiple-dimensions/m-p/775589#M1045210 morganaaron 2014-11-19T09:39:32Z Re: Rank function with multiple dimensions https://community.qlik.com/t5/QlikView/Rank-function-with-multiple-dimensions/m-p/775590#M1045211 <HTML><HEAD></HEAD><BODY><P>Add the expression</P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">rank</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">total</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Sales</SPAN><SPAN style="font-size: 8pt;">)) </SPAN></P><P></P><P></P></BODY></HTML> Wed, 19 Nov 2014 09:44:28 GMT https://community.qlik.com/t5/QlikView/Rank-function-with-multiple-dimensions/m-p/775590#M1045211 2014-11-19T09:44:28Z Re: Rank function with multiple dimensions https://community.qlik.com/t5/QlikView/Rank-function-with-multiple-dimensions/m-p/775591#M1045212 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Just Add Total in front of Sum in your expression.</P><P>=rank( Total sum(Sales))</P></BODY></HTML> Wed, 19 Nov 2014 09:49:23 GMT https://community.qlik.com/t5/QlikView/Rank-function-with-multiple-dimensions/m-p/775591#M1045212 ashwanin 2014-11-19T09:49:23Z Re: Rank function with multiple dimensions https://community.qlik.com/t5/QlikView/Rank-function-with-multiple-dimensions/m-p/775592#M1045213 <HTML><HEAD></HEAD><BODY><P>Thanks. I knew it had be something simple!</P></BODY></HTML> Wed, 19 Nov 2014 09:58:11 GMT https://community.qlik.com/t5/QlikView/Rank-function-with-multiple-dimensions/m-p/775592#M1045213 warrenpress 2014-11-19T09:58:11Z