topic Re: Syntax Error when executing sub in QlikView

Syntax Error when executing sub

lmengesha — Wed, 19 Jul 2017 15:17:05 GMT

I have the following sub routine in the scripting environment which keeps giving me a syntax error, although it only gets detected one the sub is called:

Sub traceRowCount(sTable)

if '$(sTable)' <> ''

let vNumOfRows = NoOfRows('$(sTable)');

trace >>> Number of Rows in $(sTable) : $(vNumOfRows);

let vNumOFRows = null();

else

trace >>> No table name specified;

endif

end sub

the errors occur when it reaches - if, else and endif - lines and I have no idea why, I thought it might be the table name but it isn't. I am relatively new to Qlik tech and don't know much in regards to Qliks Script environment's own language. So where am I going wrong fellas?

Re: Syntax Error when executing sub

Anil_Babu_Samineni — Wed, 19 Jul 2017 16:02:16 GMT

Looks like you missed CALL function ?? Will you provide full script ??

Re: Syntax Error when executing sub

antoniotiman — Wed, 19 Jul 2017 16:10:26 GMT

Maybe is missing then at the end of first row.

If .... then

........;

else

--------------;

endif;

Re: Syntax Error when executing sub

lmengesha — Wed, 19 Jul 2017 16:14:45 GMT

Thats exactly what was missing, I can't believe the tutorial missed that tho