topic load data with latest date in QlikView

load data with latest date

yelin_nyu — Wed, 14 Nov 2012 06:50:29 GMT

Hi,

it's kind of a miss or hit thing. sometimes it works and other times it doesn't.

I need to find values with latest date. I usually use this method, but it's too long. Any good suggestion to make my life easier? thanks

sql select distinct load_date from tbl1;

P2:

load max(load_date) as MaxDate

resident P;

let vMaxD = peek('MaxDate', 0, 'P')

drop table P;

drop table P2;

Rtble:

sql select * from tbl1

where load_date ='$(vMaxD)';

jagan — Wed, 14 Nov 2012 08:30:34 GMT

Hi,

Try this

sql select Max(load_date) from tbl1;

let vMaxD = peek('MaxDate', 0, 'P')

drop table P;

Rtble:

sql select * from tbl1

where load_date ='$(vMaxD)';

Hope this helps you.

Regards,

Jagan.

Jason_Michaelides — Wed, 14 Nov 2012 08:42:14 GMT

Maybe just move the Max() into the first SQL statement?

Load

load_date

;

sql select max(load_date) from tbl1;

let vMaxD = peek('load_date')

drop table P2;

Rtble:

sql select * from tbl1

where load_date ='$(vMaxD)';

Jason_Michaelides — Wed, 14 Nov 2012 09:43:33 GMT

Oops - not sure why I didn't see Jagan's answer there already!