topic variable LET script error in Qlik Learning Discussions

variable LET script error

Thu, 11 Dec 2014 10:07:37 GMT

Hello! Can someone explain me, please, why does

LET vMonthStart=MonthStart(max(Date));

//Date is a field of previously loaded table

cause a script line error?

Regards,

Alexa

Re: variable LET script error

its_anandrjs — Thu, 11 Dec 2014 10:24:00 GMT

It seems correct statement check the date format of Date field

try for check

=MonthStart(max(Today()))

Regards

Anand

Re: variable LET script error

Thu, 11 Dec 2014 10:44:19 GMT

Anand, thak you for your answer!

I tried to fix it..

With code like this

TempTable1:

LOAD

Max( Date) as MaxDate

Resident FACT;

Let vMaxDateNum = Num( Peek( 'MaxDate', 0, 'TempTable1'));

Let vMaxDate = Date( $(vMaxDateNum));

LET vMonthStart=MonthStart(FieldValue('MaxDate', 1));

LET vPeriod=$(vMaxDate)-$(vMonthStart);

I get another error "script line error LET vPeriod=08.12.2014-01.12.2014"

Re: variable LET script error

jonathandienst — Thu, 11 Dec 2014 10:57:29 GMT

Let evaluates the statement on the RHS before assigning it to the variable. Max(Date) is not a legal statement in script mode outside of a LOAD, so this statement is causing an error.

Your error in the second post - you need quotes around the date variables:

LET vPeriod='$(vMaxDate)'-'$(vMonthStart)';

HTH

Jonathan

Re: variable LET script error

Thu, 11 Dec 2014 11:21:49 GMT

Hello,Jonathan! thanks for explanation!!

I made it as you wrote. Now I dont get an error? but it doesnt calculate Period=(

TempTable1:

LOAD

Max( Date) as MaxDate

Resident FACT;

Let vMaxDateNum = Num( Peek( 'MaxDate', 0, 'TempTable1'));

Let vMaxDate = Date( $(vMaxDateNum));

TempTabl2:

Load MonthStart(FieldValue('MaxDate', 1)) as MonthStart,

MonthEnd(FieldValue('MaxDate', 1)) as MonthEnd

resident TempTable1;

Let vMonthStartNum = round(Num( Peek( 'MonthStart', 0, 'TempTable2')));

Let vMonthEndNum= round(Num( Peek( 'MonthEnd', 0, 'TempTable2')));

LET vPeriod='$(vMaxDateNum )'-'$(vMonthStartNum)';

LET vDaysMonth='$(vMonthEndNum)'-'$(vMonthStartNum)';

with code like this thats what I see

Re: variable LET script error

jonathandienst — Mon, 15 Dec 2014 08:41:56 GMT

You have changed the definition of the two variables to numbers, so you no longer need expansions and quotes. I think you have a trailing space in the Let vPeriod statement that is causing your problem

Simplify these two statements to:

LET vPeriod = vMaxDateNum - vMonthStartNum;

LET vDaysMonth = vMonthEndNum - vMonthStartNum;

HTH

Jonathan