Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,,
can any one pls tell me how to store table and in which format?? like in qlikview it stores in QVD form and qliksense which format..
thanks
Abhay
By default you cannot load or save files directly to a folder in Sense.
You will need to add the name of the target file as a folder data connection.
Example: 'lib://Table Files/'
Hi Abhay,
you also can store tables in QVD format in Qlik Sense but the QVD format is different then the one used in QlikView.
You can not load data from QVD files which are created in Qlik Sense in an QlikView application.
Please see also following post:
Store qvd in sense not read by qlikview?
Regards,
Ronny
Hi,
The script is almost the same as it is on QlikView. The main difference is that now the store location is a library instead of a relative or absolute path:
MyTable:
LOAD * FROM 'lib://<MyLibraryName>/<file name>.qvd' (qvd);
STORE MyTable INTO 'lib://<MyLibraryNameForStore>/<file name>.qvd' (qvd);
You can store tables in QVD or CSV format.
The QVD format used by QlikSense is different to the format used by QlikView.
Sense can access QVDs created from both QlikView or Sense, but QlikView cannot access QVDs created by Sense.
To store to QVD STORE table_name to filepath\filename.qvd (qvd) ;
To store to CSV STORE table_name to filepath\filename.qvd (txt) ;
If the format is omitted, then QVD is assumed.
hi all,
thanks for revert...
i am trying this script
Categories:
LOAD CategoryID,
CategoryName,
Description;
SQL SELECT CategoryID,
CategoryName,
Description
FROM Categories;
Store Categories to C:\Users\admin\Desktop\QlikSense\Developement\qvd\Categories.qvd(Qvd);
giving error
Syntax error, missing/misplaced FROM: Store Categories to C:\Users\admin\Desktop\QlikSense\Developement\qvd\Categories.qvd(Qvd): Store Categories to C:\Users\admin\Desktop\QlikSense\Developement\qvd\Categories.qvd(Qvd)
hi Jose,
what does it means MyLibraryNameForStore??
thanks
By default you cannot load or save files directly to a folder in Sense.
You will need to add the name of the target file as a folder data connection.
Example: 'lib://Table Files/'
Hi Colin ,
Thanks QVD save done..
want to know also like qvw in Sense where is our file save?? and in which format?
Hi Abhay,
You are getting syntax error with Store command because you are using " in" instead of "into".
Correct Syntax is
Store[ fieldlist from] table into filename [ format-spec ];
In your example script , the last line should be :
Store Categories into C:\Users\admin\Desktop\QlikSense\Developement\qvd\Categories.qvd(Qvd);