Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Maybe is missing then at the end of first row.
If .... then
........;
else
--------------;
endif;
Looks like you missed CALL function ?? Will you provide full script ??
Maybe is missing then at the end of first row.
If .... then
........;
else
--------------;
endif;
Thats exactly what was missing, I can't believe the tutorial missed that tho