topic Re: TIMESTAMP is not working in QlikView

TIMESTAMP is not working

Anonymous — Fri, 20 Apr 2018 14:14:44 GMT

I am loading date from QVD which is holding a single value . Below is the script that i am using

abc :

LOAD MaxUpdatedDate

FROM

(qvd);

let p=FieldValue('MaxUpdatedDate',1); // It is coming fine

LET vMyVariable = TIMESTAMP(FieldValue('MaxUpdatedDate',1),'DD-MMM-YYYY hh:mm:ss.fff'); // having issue with this

I am not able to see vMyVariable on screen . Please help me

Re: TIMESTAMP is not working

YoussefBelloum — Fri, 20 Apr 2018 14:29:33 GMT

Hi,

what is the format of your MaxUpdatedDate field ?

Re: TIMESTAMP is not working

jonvitale — Fri, 20 Apr 2018 14:31:59 GMT

If you use the debugger in the load script and place a breakpoint after the LET vMyVariable statement, what do you wee there?

Re: TIMESTAMP is not working

Anonymous — Fri, 20 Apr 2018 14:34:53 GMT

Hi ,

This is the format "19-Mar-2018 17:47:41.933"

Re: TIMESTAMP is not working

Anonymous — Fri, 20 Apr 2018 14:37:38 GMT

Hi ,

vMyVariable <NULL>

Re: TIMESTAMP is not working

YoussefBelloum — Fri, 20 Apr 2018 14:39:31 GMT

so here you just want to get the minimum timestamp value loaded on the abc table ?

Re: TIMESTAMP is not working

Anonymous — Fri, 20 Apr 2018 14:49:23 GMT

i want max value . Also below code is not working

abc :

LOAD

max(MaxUpdatedDate)

FROM

(qvd);

max function is not working too

Re: TIMESTAMP is not working

vishsaggi — Fri, 20 Apr 2018 14:56:55 GMT

Try this? And FieldValue() Function works only on Distinct values of the Field.

LET vMyVariable = TIMESTAMP(TIMESTAMP#(FieldValue('MaxUpdatedDate',1),'DD-MMM-YYYY hh:mm:ss.fff'));

Re: TIMESTAMP is not working

YoussefBelloum — Fri, 20 Apr 2018 15:11:09 GMT

EDITED

try this code:

abc :

LOAD Timestamp(Timestamp#(MaxUpdatedDate,'DD-MMM-YYYY hh:mm:ss.fff''),'DD-MMM-YYYY hh:mm:ss.fff') as MaxUpdatedDate

FROM

(qvd);

LET vMyVariable = Peek('MaxUpdatedDate',0, 'abc');

TRACE $(vMyVariable );

LET ME KNOW

Re: TIMESTAMP is not working

Anonymous — Wed, 25 Apr 2018 09:42:39 GMT

hi ,

Its working now . Thanks a ton

Re: TIMESTAMP is not working

YoussefBelloum — Wed, 25 Apr 2018 09:58:15 GMT

you're welcome, don't forget to close the thread