One outcome of our meeting is a list of enhancements we believe would be valuable additions to QlikView and Qlik Sense. You can view the entire working list here.
The list includes quite a few topics. Today I want to focus on improvements to Variables.
A common challenge is”script only” variables getting inadvertently promoted to the UI. There is a desire to better control and identify variables in the script.
What follows are a number of specific feature improvements for variables raised during the meeting. The general theme is to extend the current management functions for Fields to Variables as well.
- A HidePrefix and $hidden Tag for Variables. Hidden variables would not appear in the Variable overview or Expression Editor dropdown unless “Show System Variables” was checked.
- A “DROP VARIABLES vg*” statement. The DROP VARIABLE statement would delete a list of variables from both the script and UI. Script deletion of a UI variable is not possible today. Importantly, the list can include wildcards.
- Script functions that provide access to existing variables. Similar to functions currently available for Fields, the functions would be:
- COMMENT VARIABLE varname WITH ‘comment’
COMMENT VARIABLES USING mapname
Currently the only way to add comments to variables is through the Variable Overview dialog or the VBScript API. Comments are a useful feature and it would be great if comments could be set using script statements.
What do you think? Would you use these additions? Are there additional improvements you would suggest for Variables?