load data from QVD

[#1]

Hi

can any body tell me

What ways can you load data from QVD. Which one is preferred

[jagan]

Hi Venu,

If you are loading same data (For example Fact Tables(Customer details), then stored the data into QVD for the first time, and then in other dashboards load data from QVD instead of Database.  This helps in reducing the load on database.  In this scenario QVDs are used also when we are implementing Incremental load QVDs are used.

Regards,

Jagan.

[#3]

My question is how many ways we can load from qvd and how what is the prefered way to load qvd

[Anonymous]

Types of loads are,

General Load statement,

Resident Load

Preceeding load

Buffer load

Generic Load

Mapping Load

All load are based on requirement of logic implementation as each have their own significance.

If you say loading data from qvd is preferred to be optimized load rather than unoptimized.

You can check the reference manual for details about these loads

[#5]

From QVD or into a QVD?

If you mean From QVD, I believe there is only one way to load a QVD into your application and that is by using QV desktop application.

The only preferred way I know is to use the Table File option at script editor as below:

Thanks,

Angad

[its_anandrjs · Accepted solution]

Hi,

If we say loading data from qvd into the qlikview application is the best way normal table files loading like if we load any excel file,

Flat file,

csv file

same like we loading QVD file into qlikview.

Eg:-

Load *

from location

or

Load

Fieldname1,

Fieldname2

From Location;

After this load we are load any Resident table,Mapping load,Preceeding load

Hope this helps

Thanks & Regards

[jagan]

Hi,

There is only one way, ie., by using LOAD statement.

Regards,

Jagan.