topic Qlikview 11 for developers - Confirmed error in solution files in QlikView

Qlikview 11 for developers - Confirmed error in solution files

Sun, 20 Apr 2014 22:09:42 GMT

Chapter 7 file. When you reload that script, you get the errors -

Script line error:

CALL TraceRowCount('Aircraft Types')

Script line error:

CALL TraceRowCount('Aircraft Types')

Why and how do I fix ? Solution attached.

Re: Qlikview 11 for developers - Confirmed error in solution files

r_wroblewski — Tue, 20 May 2014 08:35:43 GMT

I had the same problem with a later version of solution QVWs.

After I checked and compared scripts of different files and also my own exercise file I couldn't found any difference between the files who show this error and files who count rows correctly in the load screen.

It seems that the problem is connected to the external script file which contain the subroutine.

"$(Include=tracerowcount.qvs);"

SUB TraceRowCount (SourceTable)

If '$(SourceTable)'<>'' then

LET vNoOfRows = NoOfRows('$(SourceTable)');

TRACE >>> Number of rows in $(SourceTable): $(vNoOfRows);

LET vNoOfRows = Null ();

ELSE

TRACE >>> No table name specified;

END If

END SUB

If you replace the Include Statement in your script with the original subroutine it should work again.

I also created a new external script file (p.260) and replace the subroutine inside the script.

It works without failure.

I don't really know what occurs this error but it can easily be fixed.

Greetings,

Ronny

Re: Qlikview 11 for developers - Confirmed error in solution files

r_wroblewski — Tue, 20 May 2014 08:49:38 GMT

Me again.

Just renew your Include Statement with the external script file. You don't need to do more.

Greetings,

Ronny

Re: Qlikview 11 for developers - Confirmed error in solution files

Thu, 12 May 2016 22:39:10 GMT

If you copied the script from the book, the "THEN" word is missing at the end of IF statement. The script should be:

SUB TraceRowCount (SourceTable)

// Writes the number of rows in SourceTable

// to the Script Execution Progress window.

IF '$(SourceTable)' <> '' THEN

LET vNoOfRows = NoOfRows('$(SourceTable)');

TRACE >>> Number of rows in $(SourceTable): $(vNoOfRows);

LET vNoOfRows = Null();

ELSE

TRACE >>> No table name specified;

END IF

END SUB