Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
See why BI users voted Qlik #1 in 11 categories. GET REPORT
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

STORE QVD not working

Hi All,

 

I have am trying to save a query as a QVD with the following logic:

 

LIB CONNECT TO 'MyServer';

SQL

SELECT

             stuff

FROM MyServer.USERS;

 

STORE USERS INTO [Lib://MyFolder/USERS.QVD] (qvd);

DROP TABLE USERS;

 

The error I get is "The following error occurred: Cannot open file: 'lib://MyFolder/USERS.QVD'

The error occurred here: STORE USERS INTO [Lib://MyFolder/USERS.QVD] (qvd); "

 

In data connections I have MyFolder (and I even added this to the QMC to remove my name from the library connection). And the folder exists as when testing it by putting a empty text file there, for example, I can see the file in QlikSense...

I am at a complete loss as to why this needs to be so complicated to write/access files.... Any help is appreciated!

 

 

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Hi Bill,

Yes, exactly. You don't have the right to make any changes to that folder. Contact your IT department/admin to give you the rights for this.

Good thing about this, your code is doing fine. When the access is arranged, you can implement this!

Jordy

Climber

Work smarter, not harder

View solution in original post

6 Replies
Highlighted
Partner
Partner

Hi Bill,

Try to put a file in this location (test QVD or xlsx) and try open this. This will then generate the file path for you. Use this filepath in your store command. 

If this doesn't work, try so see if you have writing problems (access), but you should notice this while working in this folder.

Jordy

Climber

Work smarter, not harder
Highlighted
Champion
Champion

Please ensure you have created lib folder  MyFolder    if  it is not there this error may come.  You can create using new connection.

 

Vikas

 

Highlighted
Contributor II
Contributor II

Yeah I created the folder and can see files from QS

 

I made a dummy txt file and could see it while in QS but I can't store any files to it using the above logic.

Highlighted
Contributor II
Contributor II

I created a test excel file and it came up with the same error - so it must be some sort of access restriction ??

Highlighted
Partner
Partner

Hi Bill,

Yes, exactly. You don't have the right to make any changes to that folder. Contact your IT department/admin to give you the rights for this.

Good thing about this, your code is doing fine. When the access is arranged, you can implement this!

Jordy

Climber

Work smarter, not harder

View solution in original post

Highlighted
Champion
Champion

try this

LIB CONNECT TO 'MyServer';

 

 

 

USERS:

Load * ;

SQL

SELECT

             stuff

FROM MyServer.USERS;

 

STORE USERS INTO [Lib://MyFolder/USERS.QVD] (qvd);

DROP TABLE USERS;