Qlikview

Document Chaining can be done using variables. We can pass values from one to another application by creating same variable in both of them.

We need to select the Include in Bookmarks checkbox present in Document Properties–> Variables tab.

This way we can achieve the document chaining using the variables.

We might think how to connect from one to another qlikview app. This is possible by doing Document Chaining. One can achieve this by using ‘Text Object/Button’.

We need to apply the ‘Open Qlikview Document’ action in the first application. 

As seen in the screenshot, we need to check Transfer State option to pass the values from first application to second application.

When we click on the button it will redirect to second application (i.e., Airline Performance_2.qvw).

Tip:

• The other application (i.e., Airline Performance_2.qvw) should be closed in order to see reflections of first application selections in second application.
• Both the applications should be present in the same folder.

The extension of an qlikview application is qvw. We can load data into the qlikview application(.qvw) in many ways using the script editor. Let us discuss few of them:

1. OLEDB Connection: 

By connecting to database and selecting the columns list from tables.

2. ODBC Connection: 

Creating an database connection in local machine and accessing it in the qlikview applications.

3. Load data from files: 

We can load data from files such as Excel, CSV, TXT, XML, or even HTML. While loading the data we can select the columns we needed.

4. Qlikview Applications:

This comes into use when we follow 3-tier architecture where same data is used in more than one application.

5. Web files:

When we want to load data from a web file, we can provide the url and load the data.

6.Load data from Qvd:

This comes into use when we follow 3-tier architecture where data is loaded into qvd files from database in another qlikview application.