topic Re: Let and Peek in QlikView

Let and Peek

afbraga1 — Sat, 16 Nov 2024 21:20:16 GMT

Hello,

Got a question concerning Peek and Let statements. I have the code below but it is returning me in the trace this - date(AddYears(YearStart(today()-1),-2),'YYYYMMDD'), when I expected to see a date.

LET v1 = Peek('Date', 'table1');

Trace $(v1);

Currently I have to do it in an extra step, in order to have the date result calculated.

LET v1 = Peek('Date', 'table1');

LET v2 = $(v1);

Trace $(v2);

Thank you.

Best regards,

André Braga

Re: Let and Peek

sunny_talwar — Wed, 27 Feb 2019 14:16:38 GMT

Try this

Table:
LOAD * INLINE [
    Date
    "Date(AddYears(YearStart(Today()-1),-2),'YYYYMMDD')"
];

LET v1 = Evaluate(Peek('Date'));

Trace $(v1);

Re: Let and Peek

afbraga1 — Wed, 27 Feb 2019 14:24:41 GMT

Ah that was it! I totally forgot about evaluate() function. Thanks Sunny.