Skip to main content
Announcements
April 9th: The AI Roadmap: 6 Landmarks for AI-ready Data and Analytics: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
piotr-bratek
Creator

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.


fsv1.png

What I've tried is presented below but the FSV function returns incorrect results. Can you pls advice where is the mistake?

fsv2.png

QVF is attached.

Thanks!

The most experienced Qlik Trainer in Central Europe
Labels (2)
1 Reply
dplr-rn
Partner - Master III

Change your expression to

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

 

that should give you the correct answr