Qlik Community

Ask a Question

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Do More with Qlik - for Beginners and Beyond, Topic: Qlik Replicate on January 21, 2PM EST. REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

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.


ex-Training Manager at Qlik Central-Eastern Europe
Labels (2)
1 Reply

Change your expression to

firstsortedvalue(Country, -aggr(max(Sales), Product,Country))


that should give you the correct answr