QlikView scripting is powerful as it allows you to transform raw data into meaningful, actionable insight. As you master scripting syntax, it is worth knowing that, sometimes, QlikView statement fails silently without giving you any error message.

Let’s look at three different pitfalls to avoid by knowing when script may fail silently.

Applymap function:

Applymap function requires mapping table name in single quote. If you misspell table name or enter table name in a different case, statement will fail yet script execution will complete without any errors.

Peek function:

Peek function requires table name and field name; both names have to be enclosed in a single quote. In addition, if you misspell either table name or field name or enter either name in a different case then the script statement fail silently without any error message.

Include statement:

Include statement allows you to include external script statements; it’s common practice to store data source — ODBC or OLEDB ¬†— connection statement¬†in a text file. This file can be included in your script using include statement. You can also store variables and expressions in an external file and include them using include statement.

The only issue is that if the include file gets deleted or moved to a different location, you won’t get an error message.

Use must_include instead of include as QlikView will raise an error message if must_include fails.

Related Posts Plugin for WordPress, Blogger...