topic Re: Getting undefined for variable in load script in QlikView

Getting undefined for variable in load script

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

Hi,

i have a a variable in Load Script with below

Load

Min(CanonicalDate) AS MinDate,

Max(CanonicalDate) AS MaxDate

RESIDENT DateBridge;

let Month_year = Date(MonthStart(peek('MaxDate'),-1),'MMM-YY');

Now in frontend

'$(Month_year )' but this gives me Undefined in textbox,

How is to get Jul-16 as answer

Regards,

Re: Getting undefined for variable in load script

tamilarasu — Fri, 26 Aug 2016 06:37:45 GMT

Hi Supriya,

Try this,

= '$(=Month_year)'

or simply

=Month_year

Re: Getting undefined for variable in load script

Anonymous — Fri, 26 Aug 2016 06:50:50 GMT

Remove $ in textbox .just use Month_year

Re: Getting undefined for variable in load script

berryandcherry6 — Fri, 26 Aug 2016 08:41:40 GMT

Hi,

No i am not getting any value,its showing blank

Re: Getting undefined for variable in load script

sunny_talwar — Fri, 26 Aug 2016 09:00:38 GMT

Can you check if the variable is getting assigned a value in the script by adding a TRACE statement?

LOAD

Min(CanonicalDate) AS MinDate,

Max(CanonicalDate) AS MaxDate

RESIDENT DateBridge;

LET Month_year = Date(MonthStart(peek('MaxDate'),-1),'MMM-YY');

TRACE $(Month_year);

Re: Getting undefined for variable in load script

varshavig12 — Fri, 26 Aug 2016 09:00:50 GMT

Also, check this: The Magic of Variables

If nothing works, share your app, someone can then help you.

Re: Getting undefined for variable in load script

berryandcherry6 — Fri, 26 Aug 2016 09:30:52 GMT

HI,

Asusual, you always help me out with new ways of debugging. Thanks for Letting me know how to debug in qlik

i am not getting any value it showing blank .

Re: Getting undefined for variable in load script

sunny_talwar — Fri, 26 Aug 2016 09:33:23 GMT

So then, your next move should be to just check this:

LOAD

Min(CanonicalDate) AS MinDate,

Max(CanonicalDate) AS MaxDate

RESIDENT DateBridge;

LET Month_year = Date(MonthStart(peek('MaxDate'),-1),'MMM-YY');

LET vTest1 = Peek('MaxDate');

TRACE $(Month_year);

TRACE $(vTest);

Re: Getting undefined for variable in load script

berryandcherry6 — Fri, 26 Aug 2016 10:03:17 GMT

No, for that also i am getting blank

Re: Getting undefined for variable in load script

sunny_talwar — Fri, 26 Aug 2016 10:06:13 GMT

This has caused a problem for me in the past, can you check this:

TableName:

LOAD

Min(CanonicalDate) AS MinDate,

Max(CanonicalDate) AS MaxDate

RESIDENT DateBridge;

LET Month_year = Date(MonthStart(peek('MaxDate'),-1),'MMM-YY');

LET vTest1 = Peek('MaxDate');

LET vTest2 = Peek('MaxDate', -1, 'TableName');

TRACE $(Month_year);

TRACE $(vTest1);

TRACE $(vTest2);

Re: Getting undefined for variable in load script

avinashelite — Fri, 26 Aug 2016 10:08:06 GMT

Share the QVW and the sample data files , will try to debug the same

Re: Getting undefined for variable in load script

Anil_Babu_Samineni — Fri, 26 Aug 2016 10:17:07 GMT

Can you post full script which you resident load also

Re: Getting undefined for variable in load script

berryandcherry6 — Mon, 29 Aug 2016 12:39:25 GMT

Hi Sunny,

TRACE $(vTest2);

Also gives blank Value.

Re: Getting undefined for variable in load script

sunny_talwar — Mon, 29 Aug 2016 12:48:41 GMT

Would you be able to share you application with us?