Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qlikview Load File

Hey

I am new to Qlikview. Let's say, I design a new qvw document which also loads data from database into Qlikview. via its load script.

If I were to design another similar qvw document which is based off similar same data, do I need to reload the data again via the load script in this new document?

Thanks,

Manish

4 Replies
oknotsen
Master III
Master III

You could also consider doing a binary load:

binary filename.qvw;

Another option is to have one application to load all data from the database, store it into QVD files, and load those QVD files by the various customer facing applications so to only contact the source system once. This is a more structured approach.

Example script to create QVDs out of your current datamodel:

SET vDataDir = 'QVDs';

for i = 0 to NoOfTables() - 1
LET d = TableName(i);
store $(d) into $(vDataDir)\$(d).QVD;
next

May you live in interesting times!
Not applicable
Author

Thanks.

So each QVW does require to load the data for its own copy whether we load it from QVD or source system?

For example if I have two QVDS each referring to the same set of fact/dimension table, either I can

(1) Load a QVD file from source system containing the fact/dimension tables, and then load this same QVD again for the two QVW's

(2) Load the same data from source system for each QVW which will take more time

(3) If possible, combine the two QVWs into one and that way we need to load the same QVW once

Let me know if this sounds correct.

simenkg
Specialist
Specialist

You should always store your tables into QVD's before loading them into your model. This isn't just for sharing the data between applications, but it will also save a lot of reloading time whenever you have to rerun your script and will reduce the load on the data base.

Create a new .QVW and after each load write:

Store TableName into TableName.qvd (qvd);

Drop table TableName;

then in your original application you simply read from this QVD instead of the database.

qlikviewwizard
Master II
Master II

Foor example you created  a datamodel with QVApp1.qvw with data.

You wanted to create another QVApp2.qvw with some other tables.

In this case you can use QVApp1.qvw in QVApp2.qvw with binary load.


You have reload QVApp2.qvw to get the data from QVApp1.qvw.


Hope this help you.


Capture.PNG