How to create the QVD files in QlikSense ?

[#1]

it's possible to create QVD file with the store function ? like that Store xyz into xyz.qvd(qvd) ?

[Josh_Good]

Yes you can creat QVDs in Qlik Sense using the same script as you would in QlikView.  If you have a script already created in QlikView, you can just drag the QVW onto Qlik Sense Desktop and it will convert to a QVF.

-Josh

[korsikov]

Yes, QVD files are created in the same way as in QlikView

example frop Sense help

New_Table:

LOAD * Inline

[Country, Region, Sales

SWE, EUR, 3.7

BEL, EUR, 0.4

NOR, EUR, 3.7

JAP, ASA, 3.6

CHN, ASA, 5.6

USA, NOA, 10.2];

STORE New_Table into File.qvd (qvd);

[#4]

Thank's Josh,

When I tried your solution my loading failed. And the  error message was :

commandes << AUTOGENERATE(1000000)

Lines fetched: 1 000 000

STORE statement only works with lib:// paths in this script mode

STORE commandes into commandes.qvd (qvd)

Échec du chargement de données

My script is :

commandes:

load
'C' & num(RecNo(),'0000000') as Commande,
'P' & num(1+floor(rand()*99999),'00000') as Produit,
1+floor(rand()*10) as Quantité
autogenerate(1000000);

STORE commandes into commandes.qvd (qvd);
DROP Table commandes;

[p_verkooijen · Accepted solution]

Hi John Doré

Create a library were you want to store the QVD, for instance named "QVDFolder" (right panel in the data load editor)

After this use this command to store:

STORE commandes INTO [lib://QVDFolder/commandes.QVD] (qvd);

[Michael_Tarallo]

Hi John - you have a few options:

• you need to either create Folder Connections for the location of the files to be stored and use the lib:// syntax , as mentioned by Paul.

OR (optional)

• you can disable Standard Mode to use the appropriate file paths as used in QlikView

See this document:

https://help.qlik.com/sense/en-US/online/index.html#../Subsystems/WorkingWith/Content/LoadData/Disab...

Please let us know how you do.

Please mark the appropriate replies as helpful / correct so our team and other members know that your question(s) has been answered to your satisfaction.

Regards,

Mike

[#7]

Hi Mike,

I selected the option mentionned by Paul.

the correct syntax is :

commandes:
load
'C' & num(RecNo(),'000000') as Commande,
  'P' & num(1+floor(rand()*99999),'00000') as Produit,
1+floor(rand()*10) as Quantité  
autogenerate(1000000);

store * from commandes into 'lib://Qlik Sense/commandes.qvd';

I created a library   name (Qlik sense) where I stored the QVD  .

[Michael_Tarallo]

Great to hear that is working - keep the disable Standard mode option in mind -- if you are planning to convert QlikView apps (if applicable) without have to create explicit Folder connections, or if you are planning on using custom QlikView connectors.

Take care.

Mike

[#9]

I don't not seem to be able to create a .qvd on the Sense Cloud - getting "file cannot be opened" with a strange path...

is this a limitation, bug - or crappy developer

[p_verkooijen]

Hi Rickard,

I think this is a limitiation.

Also be aware that the Sense cloud is limited to 25Mb per App (Total 250Mb)