QlikView – open a specific sheet / dashboard via command line

STEP 1: Get the Sheet ID of the QlikView document. You can also modify the sheet name.

Settings  –> Sheet Properties –> Sheet ID

image

STEP 2: Set the “OnOpen” Trigger in document properties and set the variable to Sheet ID.

Let us assume a variable name “SHEET” in this example.

Settings –> Document Properties –> Triggers –> Actions –> [Document Event Triggers] OnOpen –> Edit Actions –> Add –> Activate Sheet –> type value “=SHEET

image

STEP 3: You are ready for the show. Use the command qv.exe <doc.qvw> /v<sheetid>

In my example this needs to be “d:Program FilesQlikViewQv.exe” test.qvw /vSHEET=1

image

 

Loading and saving data in QlikView for beginners

How to LOAD data from a text file?

Assume your text file looks like this. Where, col1 and col2 are the column names. I call the file as “testtbl.txt”.

image

The script to load data from QlikView will be:

If you have a Table Box UI element in the sheet it will display like this when you reload:

image

How to save data from QlikView to a QVD file?

Assuming, from the above example we have data already in “testtbl” variable. Use this statement to store the data to a physical QVD file.

You can see a physical file in desk with name “test.qvd” is created. If you try to open the file in notepad, you can see an XML format data.

image

How to read data from QVD file?

Reading is similar to reading text files. But only difference is, you have to tell QlikView that this is a QVD file.

testtbl:
LOAD col1,col2 FROM test.qvd (qvd);

Note the “(qvd)” in the statement. Otherwize this will not work.

 

QlikView: Dynamically load scripts and data – based on the parameter from Publisher

Here is a sample which demonstrates two aspects:

  1. Load script dynamically based on the parameter received from the QlikView Publisher
  2. Based on some criteria, load a flat file data