Pivot table dimension

[anagharao]

Hi

I am using the below expression in the pivot table for a dimension

AGGR(MAX(PRIORITY),EMP_ID)

this works well, and provides the below table

Business Area      AGGR          Count

BA1                         4                    4

BA1                         3                    1

BA2                         4                    3

BA2                         3                    1

Now, i would like to replace the appr value with an understandable text. (desc4 for priority 4... )

Business Area      prioity desc         Count

BA1                         desc4                         4

BA1                         desc3                        1

BA2                         desc4                         3

BA2                         desc3                         1

how would i be able to do that?

[sunny_talwar · Accepted solution]

May be this

Aggr(FirstSortedValue(DISTINCT [priority desc], -PRIORITY), EMP_ID)

[anagharao]

The distinct is leading to an error.. .any suggestions ??

[anagharao]

Also, how does the formula pick up the Max values?? curious to know more..

[tresesco]

That's a known qlik parser issue. Even if that shows warning, it would work fine. Just ignore the warning and go ahead.

[tresesco]

Check this: FirstSortedValue ‒ QlikView

[sunny_talwar]

You can also look at this document, where I have tried to explain how we can get value associated with the max of another field

Value Associated with Min/Max Value of Another Field (Front End Solution)