topic LET Statement Not Working in QlikView

LET Statement Not Working

Qvmaster2019 — Fri, 16 Mar 2012 18:52:19 GMT

I think I missed out something here. The variable I created is not showing at all in my variables tab.

Here is my code.

Dynamic:

LOAD Date as Dyn_Date,

Week as Dyn_Week,

Year as Dyn_Year

FROM

[..\DataSources\ExcelFiles\BookmarkTest\Dynamic.xlsx]

(ooxml, embedded labels, table is Raw);

Let vmaxDate = max(Dyn_Date);

Please help.

Regards,

Darwin

clisboa_noesis — Fri, 16 Mar 2012 18:59:16 GMT

Hi,

You can't do it like that.

You need to do a resident load on the table Dynamic:

Dynamic_MaxDate:
LOAD
max(Dyn_Date) as MaxDate
Resident Dynamic;

then you can peek at the maxdate value.

LET vmaxDate = peek('MaxDate');

And now that we don't need dynamic_MaxDate we drop it:

drop table Dynamic_MaxDate;

Hope it helps.

Regards,

Carlos

m_woolf — Fri, 16 Mar 2012 18:59:31 GMT

Try:

Let vmaxDate = '=max(Dyn_Date)';

Qvmaster2019 — Fri, 16 Mar 2012 19:02:52 GMT

mwoolf wrote:
Try:
Let vmaxDate = '=max(Dyn_Date)';

mwoolf, this displays the vmaxDate in the Variables tab but not properly evaluating it.

Qvmaster2019 — Fri, 16 Mar 2012 19:04:23 GMT

Carlos, i will definitely try it now.

But the thing is, just yesterday, i think i was able to make it work by ticking on some options in Document Properties.