Solved: Using FirstSortedValue in a calculated dimension - Qlik Community

VivenReddy · ‎2019-09-27

From what I've read it seems like the FirstSortedValue chart function only works in an expression. What functionality is there or what workaround is available to get the same result in a calculated dimension?

rwunderlich · ‎2019-10-08

FirstSorted value may be part of a calculated dim, but it would be wrapped in aggr(). for example:

=aggr(FirstSortedValue(Salesrep, OrderDate), Customer)

-Rob

View solution in original post

Brett_Bleess · ‎2019-10-08

Viven, probably need to add a bit more detail on your use case and app in order to get response on this one...

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.

rwunderlich · ‎2019-10-08

FirstSorted value may be part of a calculated dim, but it would be wrapped in aggr(). for example:

=aggr(FirstSortedValue(Salesrep, OrderDate), Customer)

-Rob