topic Re: Firstsortedvalue issue with date in QlikView

Firstsortedvalue issue with date

Somasundaram — Sat, 16 Nov 2024 05:12:33 GMT

Hi All,

I am facing the issue with Firstsortedvalue function. attached screenshot,

Two date having same values, but i need the max date of the two dates,

=DATE(FirstSortedValue( DISTINCT DATE,-AMOUNT,'MM/DD/YYYY').

If using this expression, it gives 12/28/2015. But i want to show 12/29/2015.

Pls. suggest.

Thanks in advance,

Somasundaram

tresB — Mon, 19 Nov 2018 08:00:05 GMT

You can try adding date field with the amount filed, like:

=DATE(FirstSortedValue( DISTINCT DATE,-AMOUNT-DATE,'MM/DD/YYYY')

If your date field is really a date field (number the the back-end), this should work.

Somasundaram — Mon, 19 Nov 2018 08:12:17 GMT

Thank for your reply.

If i am using with date value, i am getting maximum date value.

not showing the correct values

tresB — Mon, 19 Nov 2018 08:29:35 GMT

Could you share your sample app?

Somasundaram — Mon, 19 Nov 2018 09:18:57 GMT

tresB — Mon, 19 Nov 2018 09:31:29 GMT

Do you need only those two columns or you have something else as dimension?

Somasundaram — Mon, 19 Nov 2018 09:33:37 GMT

I need date values based on the max amount.
Provide the both scenarios.
Thanks tresesco.

Somasundaram — Mon, 19 Nov 2018 09:47:31 GMT

Using this expression I can able to get the correct value
=DATE(DISTINCT FirstSortedValue(DATE,-(AMOUNT+DATE*0.0001)),'MM/DD/YYYY')

tresB — Mon, 19 Nov 2018 10:21:52 GMT

Great. So you can close the thread by marking correct/helpful replies.