Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
Maybe like this?
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?
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.