Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
jolivares
Specialist
Specialist

Aggr With Ranking

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.

1 Solution

Accepted Solutions
swuehl
MVP
MVP

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.

View solution in original post

3 Replies
swuehl
MVP
MVP

Maybe like this?

jolivares
Specialist
Specialist
Author

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
MVP
MVP

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.

View solution in original post