topic Re: Firstsortedvalue 2 in App Development

Firstsortedvalue 2

QlikBeginner1 — Sat, 16 Nov 2024 18:48:26 GMT

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

Re: Firstsortedvalue 2

tresB — Thu, 09 Apr 2020 11:28:04 GMT

Try passing third rank parameter with distinct qualifier, like:

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

Re: Firstsortedvalue 2

QlikBeginner1 — Thu, 09 Apr 2020 11:55:07 GMT

Thanks Tresesco!! 🙂