topic Re: Load where greater than timestamp date issue in QlikView

Load where greater than timestamp date issue

Tue, 21 Jan 2014 09:54:03 GMT

Hi Experts

I'm loading a condtional map - see below .

What I need is when a process instance has field Prev_Activity_Description = 'Contact Customer' and State_Code='CMP' and Prev_TXN_Date > '01/12/2013 08:00:00';

The issue is when I try and put the date restriction in - its like it doesnt recognise the format ( But that is the format defaulted in the charts)

Can anyone advise how to rectify ?

Thanks

My_Map:

MAPPING LOAD Process_instance, 'SME' as Flag

RESIDENT lENDERS

where Prev_Activity_Description = 'Contact Customer' and State_Code='CMP' ;

Re: Load where greater than timestamp date issue

Tue, 21 Jan 2014 09:58:44 GMT

once I said it out loud I think I resolved it

where Prev_Activity_Description = 'Contact Customer' and State_Code='CMP' and date(date(Prev_Txn_Date)) > '01/12/2013' ;

Thanks
A

Re: Load where greater than timestamp date issue

Sokkorn — Tue, 21 Jan 2014 09:59:26 GMT

Hi Anne,

You may try this

and Prev_TXN_Date > Num(Date#('01/12/2013 08:00:00','MM/DD/YYYY hh:mm:ss'));

Regards,

Sokkorn