Firstsortedvalue 2

[QlikBeginner1]

Hi,

I have a KPI which shows the top value by GWP.

FirstSortedValue({<Trade-={'-'}>}Trade, -Aggr(sum(GrossWrittenPremium), Trade))

I have been trying to figure out how to set the second highest value. I have tried many different ways looking online but the output keeps coming through as blank.

Any suggestions?

Thanks

[tresesco · Accepted solution]

Try passing third rank parameter with distinct qualifier, like:

FirstSortedValue(Distinct {<Trade-={'-'}>}Trade, -Aggr(sum(GrossWrittenPremium), Trade), 2)

[QlikBeginner1]

Thanks Tresesco!! 🙂