topic Re: Peek function creating issue for Date in QlikView

Peek function creating issue for Date

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

Hi All,

I want to determine the max date for my incremental load. But when I am using Peek function the variable is showing wrong format.

in source date is in below format:

My Script is:

Last_Date:

LOAD

Date (max(action_date$)) as MaxActionDate

FROM

(qvd);

let vMaxDate = Date(peek('MaxActionDate',0,'Last_Date'));

MaxActionDate is showing in right format:

But Variable vMaxDate is showing in wrong format:

Could you please help to get this correct.

Thanks,

Sarif

Re: Peek function creating issue for Date

MK_QSL — Thu, 13 Jul 2017 11:41:05 GMT

Instead of Let use Set

Set vMaxDate = ........

Re: Peek function creating issue for Date

sunny_talwar — Thu, 13 Jul 2017 11:43:56 GMT

Try like this

LOAD Max(action_date$) as MaxActionDate

FROM

(qvd);

LET vMaxDate = Date(Peek('MaxActionDate',0,'Last_Date'));

Re: Peek function creating issue for Date

arvind_patil — Thu, 13 Jul 2017 12:00:26 GMT

Hi Mohammad,

May it will help you:

Temp:

Load

min(TransactionDate) as minDate,

max(TransactionDate) as maxDate

Resident LinKTable;

Let varMinDate = Num(Peek('minDate', 0, 'Temp'));

Let varMaxDate = Num(Peek('maxDate', 0, 'Temp'));

DROP Table Temp;

Thanks,

Arvind Patil

Re: Peek function creating issue for Date

mhmmd_srf — Thu, 13 Jul 2017 12:25:16 GMT

Hello Sunny ,

This is also not working. I am getting result like below:

Re: Peek function creating issue for Date

sunny_talwar — Thu, 13 Jul 2017 12:28:43 GMT

I hope you are using your variable without the dollar sign expansion on the front end...

Use it as =vMaxDate instead of =$(vMaxDate)

Re: Peek function creating issue for Date

Kushal_Chawda — Thu, 13 Jul 2017 12:29:16 GMT

try this

Last_Date:

LOAD

Date(floor(max(action_date$))) as MaxActionDate

FROM

(qvd);

let vMaxDate = peek('MaxActionDate',0,'Last_Date');

Re: Peek function creating issue for Date

PrashantSangle — Thu, 13 Jul 2017 12:30:45 GMT

Date(maxActionDate);

Timestamp(maxActionDate)

Regards,

Prashant

Re: Peek function creating issue for Date

mhmmd_srf — Thu, 13 Jul 2017 13:13:46 GMT

okk..it is working..

what happens if we put $?

Re: Peek function creating issue for Date

sunny_talwar — Thu, 13 Jul 2017 13:23:26 GMT

6/30/2017 is evaluated as 6 divided by 30 divided by 2017....

Re: Peek function creating issue for Date

mhmmd_srf — Thu, 13 Jul 2017 13:40:18 GMT

okk

this is very tricky.. do u have any good doc on the variable. Like when we will use Set and when Let. When we will use $ and when not.

Re: Peek function creating issue for Date

sunny_talwar — Thu, 13 Jul 2017 13:42:08 GMT

For set and let

QlikView Addict: SET vs. LET

Dollar sign expansion

The Magic of Dollar Expansions‌

Variable

The Magic of Variables

Equal sign

The Little Equals Sign

Re: Peek function creating issue for Date

mhmmd_srf — Thu, 13 Jul 2017 13:50:15 GMT

Thanks a lot Sunny... you are always very helpful.