
Creator
2019-03-12
04:03 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
FirstSortedValue based on AGGR and two dimensions
Hi Guys,
the situation is as presented below. On the left source data, on the right - what I'm trying to get. Important! I want to calculate it in a table on a sheet.
What I've tried is presented below but the FSV function returns incorrect results. Can you pls advice where is the mistake?
QVF is attached.
Thanks!
The most experienced Qlik Trainer in Central Europe
- Tags:
- aggr()
1,394 Views
1 Reply

Partner - Master III
2019-03-12
04:23 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Change your expression to
firstsortedvalue(Country, -aggr(max(Sales), Product,Country))
that should give you the correct answr
