Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
it's possible to create QVD file with the store function ? like that Store xyz into xyz.qvd(qvd) ?
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);
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
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);
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;
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);
Hi John - you have a few options:
OR (optional)
See this document:
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
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 .
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
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
Hi Rickard,
I think this is a limitiation.
Also be aware that the Sense cloud is limited to 25Mb per App (Total 250Mb)