Qlikview Quick Tip – Exit Script

I’ve been working with Qlikview for quite some time.  Last week, a co-worker mentioned a quick tip regarding the Exit Script command.  Over the years, I haven’t encountered the need for this frequently, but when I am building a LOAD SCRIPT spanning multiple tabs, and need to do incremental testing and development, the following tip will come in handy going forward.

Qlikview Quick Tip – Exit Script

Version of Qlikview:  Version 12.0.20100.0 SR2 64-bit Edition (x64) – Personal Edition

The concept is simple.  If you are creating a LOAD SCRIPT that spans multiple tabs, and need to exit the load script at different stages during development and testing, all you need to do is create a separate LOAD SCRIPT tab with the “EXIT SCRIPT” command!

Here is a quick example:

Let’s say you have the following LOAD SCRIPT.  For example purposes, I am simply loading three different INLINE tables, one on each tab (ARIZONA, CINCY, DALLAS):

 

Qlikview Exit Script

 

Load the data, then create a simple Table Box, and you will see the following:

 

Qlikview Exit Script

 

Now, say you need to only load contents of ARIZONA and CINCY tabs.  All you need to do is add another tab, name it EXIT, and add “EXIT SCRIPT;” control statement within the script window.  Move the tab between CINCY and DALLAS.

 

Qlikview Exit Script

 

Reload the qlikview app, and now you only see contents of ARIZONA and CINCY scripts in the Table Box:

 

Qlikview Exit Script

 

That’s all there is to it.  Although this is a very simple technique, it makes development much simpler when you are working with multiple tabs in your LOAD SCRIPT, and want to incrementally test or load different tabs within your overall script.  Simply move the “Exit” tab where you need to, and it saves the hassle of moving the actual exit script control statement to the bottom of each individual tab.

Hope this helps someone else!

 

 

Additional Content

Check out more examples by visiting my Home Page

Here you will find topics covering  Qlikview  SQL Server  Excel VBA

 

 

LOAD SCRIPTS:

 

Leave a Comment