topic Re: Qlikview Load File in QlikView

Qlikview Load File

Mon, 28 Sep 2015 17:52:53 GMT

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

Re: Qlikview Load File

oknotsen — Mon, 28 Sep 2015 20:59:27 GMT

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

Re: Qlikview Load File

Mon, 28 Sep 2015 22:04:12 GMT

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.

Re: Qlikview Load File

simenkg — Mon, 28 Sep 2015 23:10:39 GMT

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.

Re: Qlikview Load File

qlikviewwizard — Tue, 29 Sep 2015 02:11:58 GMT

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.