Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Discussion Board for collaboration related to QlikView App Development.
Hi,
I need help with this Rank situation (Aggr with Dimensions) and it must be made on Script (Not in set analysis).
Situation:
Platform | Site | Value |
Mobile | EN | 100 |
Mobile | IL | 300 |
Mobile | DE | 150 |
PC | EN | 200 |
PC | IL | 400 |
PC | DE | 600 |
Crypto | EN | 400 |
Crypto | IL | 300 |
Crypto | DE | 100 |
Wanted Result:
Platform | Site | Value | Rank |
Mobile | EN | 100 | 3 |
Mobile | IL | 300 | 1 |
Mobile | DE | 150 | 2 |
PC | EN | 200 | 3 |
PC | IL | 400 | 2 |
PC | DE | 600 | 1 |
Crypto | EN | 400 | 1 |
Crypto | IL | 300 | 2 |
Crypto | DE | 100 | 3 |