Discussion board where members can learn more about Qlik Sense App Development and Usage.
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.
You were pretty close 🙂
firstsortedvalue(Country, -aggr(max(Sales), Product,Country))
Uncheck "Include zero values" under Add-ons.