topic Re: Firstsortedvalue Max in QlikView

Firstsortedvalue Max

danielnevitt — Tue, 29 Dec 2020 16:44:59 GMT

Hi,

I have data which shows the price (field name Price) bid in different markets.

I would like to create an expression which returns the below for each of the highest Prices:

MarketMaker, Price, Quantity

I thought it would be something like FirstSortedValue(MarketMaker,-aggr(Max(C1Price),MarketMaker)), however this doesn't always return a value. Would this expression not work if more than one value are the maximum Price?

Regards,
Daniel

Re: Firstsortedvalue Max

Anil_Babu_Samineni — Tue, 29 Dec 2020 16:48:24 GMT

How about simply this?

FirstSortedValue(MarketMaker, -Price)

Re: Firstsortedvalue Max

danielnevitt — Tue, 29 Dec 2020 16:51:02 GMT

Thanks again for the quick reply.

Would that expression work if there are more than one value with the maximum price? Also does it recognise negative values?

Thanks

Re: Firstsortedvalue Max

Anil_Babu_Samineni — Tue, 29 Dec 2020 16:52:47 GMT

I can say yes for both cases.

Re: Firstsortedvalue Max

danielnevitt — Wed, 30 Dec 2020 14:12:00 GMT

Sorry another quick question.

Is there a way to calculate the firstsortedvalue when the Executed field = Y.

Something like FirstSortedValue({Executed={'Y'},Buyer,-Price)?

Thanks,
Daniel

Re: Firstsortedvalue Max

Anil_Babu_Samineni — Sat, 02 Jan 2021 20:54:04 GMT

Yes, Perhaps this way

FirstSortedValue(Buyer,-Sum({<Executed={'Y'}>} Price))