topic Re: On last date lowest value min & max in QlikView

On last date lowest value min & max

qlik_2018_2 — Tue, 28 Aug 2018 14:05:16 GMT

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!

Re: On last date lowest value min & max

sunny_talwar — Tue, 28 Aug 2018 15:15:34 GMT

May be these two expressions

Max(Date)

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

Re: On last date lowest value min & max

neelamsaroha157 — Tue, 28 Aug 2018 15:29:57 GMT

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

Re: On last date lowest value min & max

sunny_talwar — Tue, 28 Aug 2018 15:46:05 GMT

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;

Re: On last date lowest value min & max

sunny_talwar — Tue, 28 Aug 2018 15:47:02 GMT

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

Re: On last date lowest value min & max

neelamsaroha157 — Tue, 28 Aug 2018 15:48:58 GMT

Thanks for correcting it . i missed it.