Qlik Community

Qlik Sense App Development

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

Not applicable

How to create the QVD files in QlikSense ?

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

1 Solution

Accepted Solutions
p_verkooijen
Valued Contributor

Re: How to create the QVD files in QlikSense ?

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

18 Replies
Employee
Employee

Re: How to create the QVD files in QlikSense ?

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
Valued Contributor II

Re: How to create the QVD files in QlikSense ?

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

Not applicable

Re: How to create the QVD files in QlikSense ?

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
Valued Contributor

Re: How to create the QVD files in QlikSense ?

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

Employee
Employee

Re: How to create the QVD files in QlikSense ?

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

Regards,
Mike Tarallo
Qlik
Not applicable

Re: How to create the QVD files in QlikSense ?

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  .

Employee
Employee

Re: How to create the QVD files in QlikSense ?

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

Regards,
Mike Tarallo
Qlik
Not applicable

Re: How to create the QVD files in QlikSense ?

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
Valued Contributor

Re: How to create the QVD files in QlikSense ?

Hi Rickard,


I think this is a limitiation.

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

Community Browser