topic Re: Aggr With Ranking in QlikView https://community.qlik.com/t5/QlikView/Aggr-With-Ranking/m-p/1071326#M357809 <HTML><HEAD></HEAD><BODY><P>The key here is that you have to create another field containing both fields, QlikView isn't capable to do that without making this field?</P></BODY></HTML> Thu, 21 Apr 2016 15:32:27 GMT jolivares 2016-04-21T15:32:27Z Aggr With Ranking https://community.qlik.com/t5/QlikView/Aggr-With-Ranking/m-p/1071324#M357807 <HTML><HEAD></HEAD><BODY><P>Hi Community, this case is about using the rank function with two or more dimensions</P><P></P><P>Take a look the QVW Attached and give your solution, thanks in advance.</P></BODY></HTML> Wed, 20 Apr 2016 23:00:40 GMT https://community.qlik.com/t5/QlikView/Aggr-With-Ranking/m-p/1071324#M357807 jolivares 2016-04-20T23:00:40Z Re: Aggr With Ranking https://community.qlik.com/t5/QlikView/Aggr-With-Ranking/m-p/1071325#M357808 <HTML><HEAD></HEAD><BODY><P>Maybe like this?</P></BODY></HTML> Wed, 20 Apr 2016 23:29:00 GMT https://community.qlik.com/t5/QlikView/Aggr-With-Ranking/m-p/1071325#M357808 swuehl 2016-04-20T23:29:00Z Re: Aggr With Ranking https://community.qlik.com/t5/QlikView/Aggr-With-Ranking/m-p/1071326#M357809 <HTML><HEAD></HEAD><BODY><P>The key here is that you have to create another field containing both fields, QlikView isn't capable to do that without making this field?</P></BODY></HTML> Thu, 21 Apr 2016 15:32:27 GMT https://community.qlik.com/t5/QlikView/Aggr-With-Ranking/m-p/1071326#M357809 jolivares 2016-04-21T15:32:27Z Re: Aggr With Ranking https://community.qlik.com/t5/QlikView/Aggr-With-Ranking/m-p/1071327#M357810 <HTML><HEAD></HEAD><BODY><P>If you want to use set analysis to filter your table lines, I think you need to use an appropriate key for the advanced search. Customer field alone would not be an sufficient key.</P><P></P><P>But if you can't create this key field in the script, you can work around this using advanced aggregation.</P><P>See attached.</P></BODY></HTML> Thu, 21 Apr 2016 23:33:08 GMT https://community.qlik.com/t5/QlikView/Aggr-With-Ranking/m-p/1071327#M357810 swuehl 2016-04-21T23:33:08Z