topic Get Max Date with Associated Value in QlikView

Get Max Date with Associated Value

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

Hello,

I have the following table, where Date format = DD/MM/YYYY:

What I need is to create a Textbox with Max value from Curve A (28,34) and Max value from Curve B (28,05).

Then, also create another Textbox with the associated Date for each Max value. Curve A = 15/8/2017 and Curve B = 9/08/2017 and 7/8/2017.

Do you know how to do that?

Thank you!!!

sunny_talwar — Wed, 17 Oct 2018 19:07:18 GMT

May be this

Concat(DISTINCT Aggr(If([Curve B] = Max(TOTAL [Curve B]), Date), Date), ', ')

and

Concat(DISTINCT Aggr(If([Curve A] = Max(TOTAL [Curve A]), Date), Date), ', ')

Nicole-Smith — Wed, 17 Oct 2018 19:16:46 GMT

These functions should work:

max([Curve A])	max([Curve B])	concat({<[Date]={'=[Curve A]=max(total [Curve A])'}>} Date, ', ')	concat({<[Date]={'=[Curve B]=max(total [Curve B])'}>} Date, ', ')
28.34	28.05	15/8/2017	7/8/2017, 9/8/2017

sergio0592 — Wed, 17 Oct 2018 19:43:25 GMT

You can also achieve with :

=concat(date(if(aggr(rank(Curve_A,0,1)=1,Date),Date)),' , ')

and

=concat(date(if(aggr(rank(Curve_B,0,1)=1,Date),Date)),' , ')