topic Re: Peek function does not work for me in QlikView

Peek function does not work for me

ananyaghosh — Wed, 25 Nov 2020 16:16:04 GMT

HI,

I am using the below code:

[Dim_Office_Updated_Date]:
load date(floor(max("UPD_TS")), 'DD/MM/YYYY') as "Max_Upd_Time" from $(vExtractPathName)\Dim_Office.qvd(qvd);
LET vMax_Updated_Time = peek('Max_Upd_Time', 0, 'Dim_Office_Updated_Date');

and get this value when I use the following variable in a text object: =$(vMax_Updated_Time )

0.0024789291026277

But if I use the column 'Max_Upd_Time' in a list box it gives me correct result.

Please suggest what to do now.

Thanks,

Sandip

Re: Peek function does not work for me

sasiparupudi1 — Fri, 03 Mar 2017 10:21:55 GMT

Wrap the variable around Time function

Time($(vMax_Updated_Time ))

LET vMax_Updated_Time =Time(Peek('Max_Upd_Time', 0, 'Dim_Office_Updated_Date'));

hth

Sasi

Re: Peek function does not work for me

marcus_sommer — Fri, 03 Mar 2017 11:15:30 GMT

Within a textbox use just: vMax_Updated_Time. The cause for your result are the '/' within your date-format which will divide your numbers against eachother within a $-sign expansion like for today:

03 / 03 / 2017 = 0.0005

But I think it would be better to remove the formatting by creating this field and variable and later if you call this variable you could add your needed format again.

- Marcus

Re: Peek function does not work for me

Anvesh — Fri, 03 Mar 2017 11:54:12 GMT

Hi sandeep,

As said by Marcus, use formatting in function like

Date(Peek('Max_Upd_Time', 0, 'Dim_Office_Updated_Date'),'DD/MM/YYYY')

if still it does not work try to change default date formatting, which will be present in first tab.

Regards

Anvesh