Variable OCD

QlikView allows variables to be added via the script and variable editor.

Sometimes you’ll come across dashboards, maybe you have created with countless variables,

  • how do we know if they’re still in use if they’re not managed?
  • How do we know old variables aren’t causing data issues that we just don’t spot?

In this video I’ll talk you though a scenario and explain how deleting variables within the script  works (and when it doesn’t).

 

https://www.youtube.com/watch?v=H3G0zLrxIgE

(Note: I’ve recorded the videos in highest resolution possible. So please view them in 1080 or 720P (HD) for best quality. Cheers!)

 

The golden rules:

  1. Declare all variables in the script (even those used in the user interface) – Remember to comment their use
  2. Delete any variables at the end of the script that are no longer required
  3. Before you release delete all the variables and run the script….. the dashboard should perform perfectly

 

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s