topic Re: Pivot table dimension in QlikView

Pivot table dimension

anagharao — Wed, 13 Dec 2017 14:02:03 GMT

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 — Wed, 13 Dec 2017 14:11:30 GMT

May be this

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

anagharao — Thu, 14 Dec 2017 06:13:45 GMT

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

anagharao — Thu, 14 Dec 2017 06:19:26 GMT

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

tresB — Thu, 14 Dec 2017 06:19:47 GMT

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

tresB — Thu, 14 Dec 2017 06:33:55 GMT

sunny_talwar — Thu, 14 Dec 2017 12:10:06 GMT

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