topic Ranking with multiple Dimensions in QlikView https://community.qlik.com/t5/QlikView/Ranking-with-multiple-Dimensions/m-p/211577#M65807 <HTML><HEAD></HEAD><BODY><P>Ok guys,</P><P>I have a straight table with customer name, invoiced dollar value and percent to total. I need to add the address, city, state and zip to it, but when I do the ranking gets all screwed up. Help. How can I rank with mulitple dimensions.</P><P>Thanks</P></BODY></HTML> Thu, 02 Dec 2010 20:00:35 GMT tmumaw 2010-12-02T20:00:35Z Ranking with multiple Dimensions https://community.qlik.com/t5/QlikView/Ranking-with-multiple-Dimensions/m-p/211577#M65807 <HTML><HEAD></HEAD><BODY><P>Ok guys,</P><P>I have a straight table with customer name, invoiced dollar value and percent to total. I need to add the address, city, state and zip to it, but when I do the ranking gets all screwed up. Help. How can I rank with mulitple dimensions.</P><P>Thanks</P></BODY></HTML> Thu, 02 Dec 2010 20:00:35 GMT https://community.qlik.com/t5/QlikView/Ranking-with-multiple-Dimensions/m-p/211577#M65807 tmumaw 2010-12-02T20:00:35Z Ranking with multiple Dimensions https://community.qlik.com/t5/QlikView/Ranking-with-multiple-Dimensions/m-p/211578#M65808 <HTML><HEAD></HEAD><BODY><P>Thom,</P><P>See my attached example. Here's the basic appoach:</P><OL><LI>Create a calculated dimension that is a concatenation of your dimensions</LI><LI>Define your actual dimensions as expressions</LI><LI>In the Presentation tab, Hide the calculated dimension</LI></OL><P>The Rank function should work out if you do this.</P><P></P><P>Hope it helps,</P><P>-Simon-</P></BODY></HTML> Fri, 03 Dec 2010 22:44:00 GMT https://community.qlik.com/t5/QlikView/Ranking-with-multiple-Dimensions/m-p/211578#M65808 2010-12-03T22:44:00Z Ranking with multiple Dimensions https://community.qlik.com/t5/QlikView/Ranking-with-multiple-Dimensions/m-p/211579#M65809 <HTML><HEAD></HEAD><BODY><P>Thanks Simon,</P><P>It works perfectly.......have a great day.</P><P>Thom</P></BODY></HTML> Mon, 06 Dec 2010 15:00:19 GMT https://community.qlik.com/t5/QlikView/Ranking-with-multiple-Dimensions/m-p/211579#M65809 tmumaw 2010-12-06T15:00:19Z Re: Ranking with multiple Dimensions https://community.qlik.com/t5/QlikView/Ranking-with-multiple-Dimensions/m-p/211580#M65810 <HTML><HEAD></HEAD><BODY><P>Simple. Brilliant.</P><P></P><P>Much Respect!</P></BODY></HTML> Thu, 23 Apr 2015 11:27:19 GMT https://community.qlik.com/t5/QlikView/Ranking-with-multiple-Dimensions/m-p/211580#M65810 2015-04-23T11:27:19Z