topic FirstSortedValue() in QlikView

FirstSortedValue()

souadouert — Wed, 25 Nov 2020 16:16:04 GMT

Hello
I have a question about the arguments of the FirstSortedValue function in the graphs , my expression

Count(aggr(Count(DISTINCT {<ID = {"=Index(Concat(DISTINCT {<YEAR= {$(=(YEAR))}>} '|' & REACT& '|'), '|1|')
and FirstSortedValue(PRICE1+PRICE2, -DATE) > 0"}>} ID),ID))

the expression is working correctly but I have to add a condition on the date

FirstSortedValue(PRICE1+PRICE2, -DATE>20181231) > 0"}>} ID)

Count(aggr(Count(DISTINCT {<ID = {"=Index(Concat(DISTINCT {<YEAR= {$(=(YEAR))}>} '|' & REACT& '|'), '|1|')
and FirstSortedValue(PRICE1+PRICE2, -DATE>20181231)> 0"}>} ID),ID))

Re: FirstSortedValue()

sunny_talwar — Wed, 08 May 2019 10:59:06 GMT

May be using set analysis

FirstSortedValue({<DATE = {[>$(=Date(MakeDate(2018, 12, 31), 'DateFieldFormatHere'))]}>} PRICE1+PRICE2, -DATE)

Re: FirstSortedValue()

souadouert — Wed, 08 May 2019 11:04:47 GMT

THANK YOU SUNNY

Re: FirstSortedValue()

sunny_talwar — Wed, 08 May 2019 11:07:41 GMT

Your always welcome Souad 🙂