can you explain me about QVD?what its purpose and it should to apply?with example?

[#1]

can you explain me about QVD?what its purpose and it should to apply?with example?

[ychaitanya]

QVD is a Qlikview Data File...

Purpose:

which provides the security in Qlikview as we can only open QVDs in the Qlikview

Compression Ratio : it compresses the file size to 10% of its original

Faster access : as this is an internal file of Qlikview..

We can Load data from our data sources and store into qvds and can re-use those qvds for better access and faster responsiveness.

Example:

Sample_Table:

Load Col1,

Col2,

Col3

from Table.xls

STORE Sample_Table into MySampleQVD.qvd (qvd);

We can re-use the above qvd again in our data model..as below

QVD_Load_Table:

Load * from MySampleQVD (qvd);

Hope this helps...

Please mark the posts as helpful or answered as this will help others in community.

Thanks

Chaitanya

[ashfaq_haseeb]

Hi,

Check this

http://community.qlik.com/thread/139509

Regards

ASHFAQ

[jagan]

Hi Yogesh,

QVDs stores retrieved from the source/databases.  QVDs are generally used to reduce the database hits.  Assume that you have 10 Dashboards and uses the same table Table1, in this scenario if you fetch the data from database in every dashboard then the database i hits 10 times, also the loading of the dashboards is also more, also there may be chances that all the dashboards should not have same numbers because different dashboards are loaded at different intervals.

To overcome we will create a QVD in first dashboard and use the same qvd in the remaining dashboards, this way we will reduce the load on databases and reduced the 9 hits.

Hops this helps you.

Regards,

Jagan.

[Andrea_Ghirardello]

I agree with all.

If you want to see a simple example on how save and load data from qvds, see here Test_Input_Field.zip

Hope this helps.

[#6]

thanks!!!!!!!!!!!!!!!!!!!!!!

[#7]

Thanks!!!!!!!!

[#8]

qvd:  qlikview data file . 

qvd is heart of the qlikview  ,if qvd is not there then we can't imagine qlikview,

qvd uses:

1)once u load the data from database and extracted a qvd, then here after u no need to connect to database your data will be reside in qvd.

2)loading data from qvd is 10-100 times faster than loading from database.

3) incremental load is implemented on basis of qvd's.

3)  load

banana,

apple,

orange

from products;

store products  into  c\....\products.qvd;

pls close this thread by making appropriate answer

[its_anandrjs]

Hi,

QVD is stands for Qlikview Data file which is created in the Qlikview and used in the qlikview applications it self and which is much faster to access in compare to other sources. QVD compressed the stored data into QVD and thats why it is fast access and many advantages of this QVD as if created once again and again we add data into this by replace the records and add more rows into the QVD. And this QVd can access to different application like for other departments or the domains as well as.

For creating QVD store command is used

TableName:

Load  *

From Source;

Syntax:

Store TableName into TableName.qvd(qvd);

For accessing QVD same as other excel or txt file but extension is *.Qvd

Load *

From TableName.qvd(qvd);

Regards

Anand

[jagan]

Hi,

If you got the answer please Close this thread.

Regards,

Jagan.