topic Re: Firstsortedvalue in QlikView

Firstsortedvalue

master_student — Mon, 20 Feb 2017 14:13:55 GMT

Hello

here's my table

I need to get the row with the max(valid_from) date

I use this expression : Firstsortedvalue(msis,-Aggr(max(valid_from),msis)) and this is the result :

Any idea please?

Thanks

annafuksa1 — Mon, 20 Feb 2017 14:16:13 GMT

can you upload your app ?

master_student — Mon, 20 Feb 2017 14:33:00 GMT

I attached it in my first request

vishsaggi — Mon, 20 Feb 2017 15:27:19 GMT

Try this?

master_student — Mon, 20 Feb 2017 15:34:39 GMT

Thank, will try and let you know