Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
anagharao
Creator II
Creator II

Pivot table dimension

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?

1 Solution

Accepted Solutions
sunny_talwar

May be this

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

View solution in original post

6 Replies
sunny_talwar

May be this

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

anagharao
Creator II
Creator II
Author

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

anagharao
Creator II
Creator II
Author

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

tresesco
MVP
MVP

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

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)