On last date lowest value min & max

[qlik_2018_2]

Hi everybody,

could you please help me with this?

This is my table:

and this is what I would like to get:

For A last day (max) and the lowest number on that day(min).

I already tried these:

for date max(date) and for value if (max(date)=date, min(L,R)), but it doesn't work. Or in case only max(date) and min(L,R) I get last date, but lowest number for all measurements. In case of C 01/01/2018 value:1010, but this is not the lowest on that day.

Thanks for your help!

[sunny_talwar]

May be these two expressions

Max(Date)

FirstSortedValue(RangeMin(L, R), -Date)

[neelamsaroha157]

If you want to handle it at the script level, check this.

[sunny_talwar]

This doesn't seem right

I think you wanted to do this

LOAD Field, Date(Max(Date), 'DD/MM/YYYY') as MaxDate, FirstSortedValue(MinM, -Date) as MinNum

Resident t1 Group by Field;

[sunny_talwar]

Min(MinM) will find the Min regardless of the max date, where as OP seems to need the min between L or R for the max date

[neelamsaroha157]

Thanks for correcting it . i missed it.