topic Re: How to create the QVD files in QlikSense ? in App Development

How to create the QVD files in QlikSense ?

Wed, 24 Sep 2014 14:18:16 GMT

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

Re: How to create the QVD files in QlikSense ?

Josh_Good — Wed, 24 Sep 2014 14:23:05 GMT

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

Re: How to create the QVD files in QlikSense ?

korsikov — Wed, 24 Sep 2014 14:27:45 GMT

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

Re: How to create the QVD files in QlikSense ?

Wed, 24 Sep 2014 14:32:42 GMT

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;

Re: How to create the QVD files in QlikSense ?

p_verkooijen — Wed, 24 Sep 2014 14:43:01 GMT

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

Re: How to create the QVD files in QlikSense ?

Michael_Tarallo — Wed, 24 Sep 2014 15:57:23 GMT

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/DisableStandardMode.htm?H…

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

Re: How to create the QVD files in QlikSense ?

Wed, 24 Sep 2014 16:30:27 GMT

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 .

Re: How to create the QVD files in QlikSense ?

Michael_Tarallo — Wed, 24 Sep 2014 16:33:33 GMT

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

Re: How to create the QVD files in QlikSense ?

Wed, 03 Feb 2016 16:23:54 GMT

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

Re: How to create the QVD files in QlikSense ?

p_verkooijen — Wed, 03 Feb 2016 19:57:06 GMT

Hi Rickard,

I think this is a limitiation.

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

Re: How to create the QVD files in QlikSense ?

Josh_Good — Wed, 03 Feb 2016 20:23:29 GMT

‌Hi Rickard,

This is a current limitation of Qlik Sense Cloud.

-Josh

Qlik

Re: How to create the QVD files in QlikSense ?

fatihtomruk — Thu, 04 Feb 2016 07:50:32 GMT

please see this page.

https://community.qlik.com/thread/79243

Re: How to create the QVD files in QlikSense ?

Thu, 04 Feb 2016 08:53:36 GMT

Can i create the QVD in the desktop - upload it to "My Personal Data files" - and use it from there?

Re: How to create the QVD files in QlikSense ?

Wed, 10 Feb 2016 15:54:28 GMT

I am not able to create library. I want to create library to store a table.

Re: How to create the QVD files in QlikSense ?

shayraber — Tue, 13 Dec 2016 08:51:26 GMT

hi,

what if I don't have a "create library" option?

(see attached screenshot)

Re: How to create the QVD files in QlikSense ?

p_verkooijen — Tue, 13 Dec 2016 14:53:05 GMT

Hi shayraber‌,

It should show a option named Folder, are you working on a Qlik Sense server?

Re: How to create the QVD files in QlikSense ?

shayraber — Tue, 13 Dec 2016 21:27:20 GMT

Hi Paul,

yes. i DO use a Sense Server and one user can see the "Folder" option and the other don't...

Re: How to create the QVD files in QlikSense ?

p_verkooijen — Wed, 14 Dec 2016 07:48:54 GMT

Hi shayraber‌,

If some users can see the Folder option, you should compare the roles / rights.

Re: How to create the QVD files in QlikSense ?

shayraber — Wed, 14 Dec 2016 08:09:13 GMT

hi Paul,

Thanks!

that solved the issue.

i gave the other user the role that the first user had and it worked. i thought that might be the issue BUT i was wired to me since i had an option to load via ODBC for example and i didn't see any reason that i won't be able to load from (or store to) folder

10x a lot!