Problem loading data into qlikview (binary/qvd)

Tue, 16 Sep 2014 07:50:47 GMT

Hello everyone !
I am fairly new to Qlikview and working on a new dashboard for my company. I am having trouble getting the data into Qlikview from different sources. Firstly, I did a binary load of another massive file. Now I came to know that we can only do one binary load at a time. I also want to replicate most of the data from one more Qlikview file. I've heard a bit about qvd but not sure how effective it is and how to use it. The file which I now want to load is also a bit complicated (according to me) and have several tabs in the script. Can someone please guide me how to load that QVW file into my Qlikview apart from binary load.

Thanks

Zarar

Re: Problem loading data into qlikview (binary/qvd)

jagan — Tue, 16 Sep 2014 08:02:35 GMT

Hi,

If you want to load QVW file into another QVW file then binary Load is the only option.

If you want to add some more tables to that you add the additional load script in your Qlikview file.

A QVD is used to store one table data as a physical file, we can load any number of QVD files in Qlikview file. To create QVD file try like this

Data:

LOAD

FROM DataSource;

STORE Data INTO Data.qvd;

To load QVD file into Qlikview file then try like below

Data:

LOAD

FROM Data.qvd (qvd);

Hope this helps you.

Regards,

Jagan.

topic Problem loading data into qlikview (binary/qvd) in QlikView

Problem loading data into qlikview (binary/qvd)

Re: Problem loading data into qlikview (binary/qvd)