topic Re: mystery if then else error in script in QlikView

mystery if then else error in script

Mon, 14 Oct 2013 18:05:11 GMT

Hello,

I'm having trouble with if/then/else in a script. I had this working in a different document, but I get script errors now. The exact script below throws the error. If I comment out the If/Endif statement, it runs fine. What am I missing (I know it's something painfully obvious, but I've been searching Google and the forums for ~60 mins with no luck).

Once I solve the "outer" if/then, I need to work on the inner if/then, but one thing at a time!

Thanks!

Re: mystery if then else error in script

Clever_Anjos — Mon, 14 Oct 2013 18:09:19 GMT

Is there any

LET vCount

BEFORE the for "loop"?

Re: mystery if then else error in script

Mon, 14 Oct 2013 18:12:09 GMT

Yes. I LET vCount = 0; before the loop. This was working in the other document I created.

Re: mystery if then else error in script

Clever_Anjos — Mon, 14 Oct 2013 18:26:01 GMT

What is the exact error message?

Re: mystery if then else error in script

rustyfishbones — Mon, 14 Oct 2013 18:29:02 GMT

Have you defined the variable for

vTargetOut

Is it looking in the correct directory

Re: mystery if then else error in script

Mon, 14 Oct 2013 18:36:08 GMT

Alan,

I know everything is working apart from the if/then because everything works properly when I comment out the if/then (see below).

Thanks!

Re: mystery if then else error in script

Anonymous — Mon, 14 Oct 2013 19:05:54 GMT

Somehting's wrong with vCount... What the error is?

Try to run in the debug mode.

Re: mystery if then else error in script

Mon, 14 Oct 2013 19:11:00 GMT

Well.... the error was "Script Error: ENDIF". After several iterations of commenting and uncommenting pieces of the if clause, the script now works. I didn't make any changes to the code itself. This is weird. Here's the working code:

I'll chalk this up to gremlins and proceed with fingers crossed. Thank you for your help!

Re: mystery if then else error in script

Mon, 14 Oct 2013 19:12:08 GMT

Well... as mentioned above, this is now mysteriously working with no code changes. I have no idea what happened!

Thank you for your help, though!

Re: mystery if then else error in script

Clever_Anjos — Mon, 14 Oct 2013 19:21:00 GMT

Well...

Maybe because Oct 31 is coming

Re: mystery if then else error in script

Wed, 16 Oct 2013 15:10:54 GMT

Well..... I continued having script gremlins. The debugger and the "normal" reload would intermittently throw "script error: endif" errors. I eventually made this go away by changing to a switch on a boolean:

I think the compiler must do some crazy partial evaluation behind the scenes... hence the sporadic errors with the prior syntax.