topic Rank Result as dimension? in QlikView https://community.qlik.com/t5/QlikView/Rank-Result-as-dimension/m-p/32742#M5543 <HTML><HEAD></HEAD><BODY><P>I wish to use the Rank of a field with unique&nbsp; values as&nbsp; dimension but the chart displays the message that the memory does not suffice.</P><P></P><P>Can I circumvent this?</P><P></P><P>I use at most 6 selections.</P></BODY></HTML> Mon, 30 Apr 2018 05:18:39 GMT chrweber 2018-04-30T05:18:39Z Rank Result as dimension? https://community.qlik.com/t5/QlikView/Rank-Result-as-dimension/m-p/32742#M5543 <HTML><HEAD></HEAD><BODY><P>I wish to use the Rank of a field with unique&nbsp; values as&nbsp; dimension but the chart displays the message that the memory does not suffice.</P><P></P><P>Can I circumvent this?</P><P></P><P>I use at most 6 selections.</P></BODY></HTML> Mon, 30 Apr 2018 05:18:39 GMT https://community.qlik.com/t5/QlikView/Rank-Result-as-dimension/m-p/32742#M5543 chrweber 2018-04-30T05:18:39Z Re: Rank Result as dimension? https://community.qlik.com/t5/QlikView/Rank-Result-as-dimension/m-p/32743#M5544 <HTML><HEAD></HEAD><BODY><P>Its tricky to help you with an expression without knowing anything about the table, data model and the expression you have attempted. I suggest you supply a lot more information, and best would be if you supply a small sample qvw that illustrates the problem with a clear explanation of precisely what what output you expect.</P></BODY></HTML> Mon, 30 Apr 2018 07:06:01 GMT https://community.qlik.com/t5/QlikView/Rank-Result-as-dimension/m-p/32743#M5544 jonathandienst 2018-04-30T07:06:01Z Re: Rank Result as dimension? https://community.qlik.com/t5/QlikView/Rank-Result-as-dimension/m-p/32744#M5545 <HTML><HEAD></HEAD><BODY><P>Please post some samples and use Rank as expression in a Straight table and try if that works out </P></BODY></HTML> Mon, 30 Apr 2018 10:57:33 GMT https://community.qlik.com/t5/QlikView/Rank-Result-as-dimension/m-p/32744#M5545 qliksus 2018-04-30T10:57:33Z Re: Rank Result as dimension? https://community.qlik.com/t5/QlikView/Rank-Result-as-dimension/m-p/32745#M5546 <HTML><HEAD></HEAD><BODY><P>Please check the table Rank as Dimension.</P></BODY></HTML> Wed, 02 May 2018 04:56:49 GMT https://community.qlik.com/t5/QlikView/Rank-Result-as-dimension/m-p/32745#M5546 chrweber 2018-05-02T04:56:49Z Re: Rank Result as dimension? https://community.qlik.com/t5/QlikView/Rank-Result-as-dimension/m-p/32746#M5547 <HTML><HEAD></HEAD><BODY><P>Try using rank() with aggr(), like:</P><P></P><P>Aggr(Rank(Dimension), Dimension)</P><P></P><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/201213_Capture.JPG" style="height: auto;" /></P></BODY></HTML> Wed, 02 May 2018 05:05:57 GMT https://community.qlik.com/t5/QlikView/Rank-Result-as-dimension/m-p/32746#M5547 tresB 2018-05-02T05:05:57Z