Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
piotr-bratek
Creator
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)
2 Replies
crusader_
Partner - Specialist
Partner - Specialist

Hi Piotr,

You were pretty close 🙂

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

PFA example.

//Andrei

NZFei
Partner - Specialist
Partner - Specialist

Dim1:

Product

 

Dim2:

Country

 

Measure:

if(rank(Sum(Sales))=1,
 sum(Sales)
)

Uncheck "Include zero values" under Add-ons.