topic Re: loading max time of a date in QlikView

loading max time of a date

Thu, 04 Jun 2015 09:59:26 GMT

Hi all,

Any help is much appreciated on the following:

I have the following dates:

I only want to load the most recent time of each date. ie:

As this has been edited most recently

I can't seem to get the max function to work here.

Thanks,

PrashantSangle — Thu, 04 Jun 2015 10:03:57 GMT

Hi,

USe max(Date(Date#(DateField,'DD.MM.YYYY hh:mm')))

Regards

alexandros17 — Thu, 04 Jun 2015 10:05:09 GMT

To do this use the following logic:

Tab1:

Load a,b,c resident mytab; // The field c is the one for which you need the max for each a value

left join

Load a, max(c) as maxValPerKey resident Tab1 Group by a;

Let me know

swuehl — Thu, 04 Jun 2015 10:05:35 GMT

Maybe something like

DATA:

LOAD

TimestampField,

...

FROM ...;

INNER JOIN LOAD

Timestamp(max(TimestampField)) as TimestampField

RESIDENT DATA

GROUP BY Daystart(TimestampField);