topic Re: [Qlik Sense] - Store into QVD in App Development

[Qlik Sense] - Store into QVD

Fri, 26 Dec 2014 13:32:30 GMT

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

Re: [Qlik Sense] - Store into QVD

Gysbert_Wassenaar — Fri, 26 Dec 2014 13:44:11 GMT

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);

Re: [Qlik Sense] - Store into QVD

Tue, 04 Aug 2015 12:11:33 GMT

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

Re: [Qlik Sense] - Store into QVD

Tue, 04 Aug 2015 12:17:12 GMT

Excuse me, I solved it

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

using the last ' in the correct position