Qlikview 11 for developers - Confirmed error in solution files

[#1]

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.

[r_wroblewski]

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

[r_wroblewski]

Me again.

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

Greetings,

Ronny

[#4]

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