Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

[Qlik Sense] - Store into QVD

   Hi All,

easy to do in Qlikview, but i'm lost in this new product.

How to store a table into a QVD ? how get those datas from the QVD ???

regard

Tags (1)
1 Solution

Accepted Solutions

Re: [Qlik Sense] - Store into QVD

First you need to add a Data Connection of the Folder type. Once you've created this you can use it to store and read qvd files. In the example below a Data Connection with the name QVData was created first and then used in the load and store statements.

Transactions:

LOAD * FROM 'lib://QVdata/salestodate.qvd' (qvd);

STORE Transactions INTO 'lib://QVdata/Transactions.qvd' (qvd);


talk is cheap, supply exceeds demand
3 Replies

Re: [Qlik Sense] - Store into QVD

First you need to add a Data Connection of the Folder type. Once you've created this you can use it to store and read qvd files. In the example below a Data Connection with the name QVData was created first and then used in the load and store statements.

Transactions:

LOAD * FROM 'lib://QVdata/salestodate.qvd' (qvd);

STORE Transactions INTO 'lib://QVdata/Transactions.qvd' (qvd);


talk is cheap, supply exceeds demand
Not applicable

Re: [Qlik Sense] - Store into QVD

Hi Gysbert!

And to store a table named as a variable?

if your table name is a variable, for example: $(TableName) (value is 'MyTable')

Store $(TableName) into 'lib://Qvdata/$(TableName).qvd (qvd);

Doesn´t works. I have a check control on debugging mode and Qlik sense is doing that:

store MyTable into 'lib://Qvdata/$(TableName).qvd (qvd);

and I have a QVD file named $(TableName) and I need that the QVD file is named as MyTable

Thank you

Not applicable

Re: [Qlik Sense] - Store into QVD

Excuse me, I solved it

Store $(TableName) into 'lib://Qvdata/$(TableName).qvd' (qvd);

using the last ' in the correct position

Community Browser