Aggr With Ranking

[jolivares]

Hi Community, this case is about using the rank function with two or more dimensions

Take a look the QVW Attached and give your solution, thanks in advance.

[swuehl]

Maybe like this?

[jolivares]

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?

[swuehl · Accepted solution]

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.

But if you can't create this key field in the script, you can work around this using advanced aggregation.

See attached.