Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Using FirstSortedValue in a calculated dimension

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?

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

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

2 Replies
Highlighted
Digital Support
Digital Support

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.
Highlighted
MVP & Luminary
MVP & Luminary

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