topic Want to choose a single value in QlikView

Want to choose a single value

RishabhTFC — Mon, 26 Jan 2026 18:19:17 GMT

Hello Guys,

I am facing a problem. Actually I had this product 111 and I want to use the price value of latest start date but the problem is that there are two similar columns and I want to use only one that is 13.

I am using

FirstSortedValue(Price,-Price_Start_Date)

but it shows me "-" in KPI any suggesstion how can I use it.

Thanks

Re: Want to choose a single value

olivierrobin — Mon, 02 Jul 2018 07:18:49 GMT

hello

your 2 prices have the same start date, so you are not sure of the one retrieved by the function

Re: Want to choose a single value

tresB — Mon, 02 Jul 2018 07:26:12 GMT

Try like:

FirstSortedValue(Price,-Price_Start_Date-Price)