Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
microwin88x
Creator III
Creator III

Get Max Date with Associated Value

Hello,

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

DateCurve ACurve B
1/8/201726,6226,97
2/8/201726,7826,83
3/8/201726,6326,80
4/8/201726,7326,86
7/8/201726,3528,05
8/8/201726,2726,75
9/8/201726,8028,05
10/8/201727,1026,96
11/8/201727,3527,47
14/8/201727,5227,69
15/8/201728,3425,69

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!!!

3 Replies
sunny_talwar

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

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.3428.0515/8/20177/8/2017, 9/8/2017
sergio0592
Specialist III
Specialist III

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)),' , ')