topic Re: load data from QVD in QlikView

load data from QVD

Mon, 24 Mar 2014 05:05:37 GMT

can any body tell me

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

Re: load data from QVD

jagan — Mon, 24 Mar 2014 05:14:19 GMT

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.

Re: load data from QVD

Mon, 24 Mar 2014 05:16:06 GMT

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

Re: load data from QVD

Anonymous — Mon, 24 Mar 2014 05:35:49 GMT

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

Re: load data from QVD

Mon, 24 Mar 2014 05:37:46 GMT

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

Re: load data from QVD

its_anandrjs — Mon, 24 Mar 2014 05:48:49 GMT

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

Load

Fieldname1,

Fieldname2

From Location;

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

Hope this helps

Thanks & Regards

Re: load data from QVD

jagan — Mon, 24 Mar 2014 05:50:12 GMT

Hi,

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

Regards,

Jagan.