Summary: I provide a tool to check your script for compatibility with QlikView version 12.
I’ve blogged about a couple of script changes in QV12 here. Since then I’ve also noticed that the $(include) statement is also affected by the Directory statement. That is, if the script below works in QV11, it will not work in QV12:
DIRECTORY Data; $(Must_Include=config.txt);
This is because QV11 looks for the file in the working directory where the QVW is, whereas QV12 will respect the DIRECTORY statement and look in the Data directory.
To summarize compatabilty considerations for QV12:
- QV12 changes the way script EXECUTE statement is authorized.
- QVD*() functions respect the DIRECTORY statement.
- $(include) and $(Must_include) respect the DIRECTORY statement.
How will you know if you have existing script that may be impacted by these changes in QV12? In an earlier post, I introduced the Script Repository tool which can be used to search script across QVWs.
You can use the tool to search for potential issues. But I thought I would make it a bit easier by adding a dedicated “Version 12 Upgrade Check” sheet that does the searching and highlighting for you.
The chart at the top of the sheet will list any document that has script that should be examined further. Select a document, press the highlight button and the script of interest will be outlined in yellow.
My guess is that most customers will not have any compatibility issues. But why take chances? Be a hero and scan your script before upgrading.
Join me at an upcoming Masters Summit for Qlik event in Johannesburg (6-8 Sept) or Austin (10-12 Oct). In my Advanced Scripting session, in addition to teaching important scripting techniques, we’ll look at methods and tools for managing your “script farm”.