topic Re: Script line Error : if in QlikView

Script line Error : if

Sat, 20 Jun 2015 07:04:21 GMT

Hi :

Can someone help me know what is wrong in my report?

Please find the attached error.

Script:

LET todaytime = Date(Now(), 'dd');

LET Midstart = NUM(17,'00') ;

LET MidEnd = NUM(31,'00') ;

LET start = NUM(1,'00') ;

LET End = NUM(16,'00') ;

if $(vToday) >= $(Midstart ) and $(vToday) <=$(MidEnd )

else if $(vToday) >= $(start ) and $(vToday) <=$(End )

thanks

kyoko

Re: Script line Error : if

PrashantSangle — Sat, 20 Jun 2015 07:17:10 GMT

Hi,

go to Help Menu and see IF

Regards

Re: Script line Error : if

Sat, 20 Jun 2015 07:26:05 GMT

HI @max dreamer

How can I go to "Help Menu" in this Community?

thanks

Re: Script line Error : if

MK_QSL — Sat, 20 Jun 2015 07:36:07 GMT

Use ' ' when you call variable..

' $(vToday)'

Re: Script line Error : if

abhaysingh — Sat, 20 Jun 2015 07:36:43 GMT

Hi Kyoko,

could you please tell me what you have define in vToday variable..

thanks

Re: Script line Error : if

abhaysingh — Sat, 20 Jun 2015 07:38:32 GMT

it seems you have not define variable vToday thats why giving such error

Re: Script line Error : if

Sat, 20 Jun 2015 07:40:58 GMT

HI AbhaySingh‌

About "vToday"

LET ThisExecTimeDate = Date(Now(), 'dd');

LET vToday = Num($(ThisExecTimeDate), '00');

Re: Script line Error : if

Sat, 20 Jun 2015 07:42:36 GMT

HI @MRKachhiaIMP :

when I use ' $(vToday)' .

Re: Script line Error : if

maxgro — Sat, 20 Jun 2015 08:43:59 GMT

2 small example

LET vToday = day(Now());

IF $(vToday) >= 17 and $(vToday)<=31 THEN

trace '17..31';

ELSEIF $(vToday) >= 1 and $(vToday) <=16 THEN

trace '1..16';

ENDIF;

and with variables

LET Midstart = 17;

LET MidEnd = 31;

LET Start = 1;

LET End = 16;

LET vToday = day(Now())-10;

if $(vToday) >= $(Midstart) and $(vToday) <=$(MidEnd) THEN

trace '17..31';

ELSEIF $(vToday) >= $(Start) and $(vToday) <=$(End) THEN

trace '1..16';

ENDIF;

Re: Script line Error : if

Sat, 20 Jun 2015 13:09:04 GMT

If your working with variables & varibales holds number use $(vName) or vName. If the variable holds string use '$(vName)'