topic Re: Using FirstSortedValue in a calculated dimension in QlikView

Using FirstSortedValue in a calculated dimension

VivenReddy — Fri, 27 Sep 2019 17:52:49 GMT

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?

Re: Using FirstSortedValue in a calculated dimension

Brett_Bleess — Tue, 08 Oct 2019 15:28:37 GMT

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

Re: Using FirstSortedValue in a calculated dimension

rwunderlich — Tue, 08 Oct 2019 15:36:52 GMT

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

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

-Rob