How to store table in qliksense

[abhaysingh]

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

[r_wroblewski]

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

[#3]

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

[Colin-Albert]

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.

[abhaysingh]

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)

[abhaysingh]

hi Jose,

what does it means  MyLibraryNameForStore??

thanks

[Colin-Albert · Accepted solution]

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/'

[abhaysingh]

Hi Colin ,

Thanks QVD save done..

want to know also like qvw in Sense where is our file save?? and in which format?

[ssb]

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