Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

abhaysingh
Contributor III

How to store table in qliksense

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

1 Solution

Accepted Solutions

Re: How to store table in qliksense

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

8 Replies
r_wroblewski
Contributor III

Re: How to store table in qliksense

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

Not applicable

Re: How to store table in qliksense

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

Re: How to store table in qliksense

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

Re: How to store table in qliksense

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

Re: How to store table in qliksense

hi Jose,

what does it means  MyLibraryNameForStore??

thanks

Re: How to store table in qliksense

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

Re: How to store table in qliksense

Hi Colin ,

Thanks QVD save done..

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

ssb
New Contributor II

Re: How to store table in qliksense

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

Community Browser