Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
parevrac
Contributor III
Contributor III

Syntax for FROM statement to load from existing QVD

I am very new to QlikSense and am attempting to replicate a data load script from one of my existing Qlikview docs but it is failing to load.

I have created a Data Connection - "My Data" and changed the FROM statement within the load script to

FROM [lib://My Date/Filename.qvd (qvd)]  - several other variations BUT the load fails every time with a 'cannot open file' error

I have also tried to select the file from the Data Connection but this just hangs (I can see the full list of files when I select Edit Data Connection)

I am able to drag the qvd file into the QlikSense document BUT I want to restrict the data load which is why I need to replicate the load script from the original Qlikview document

4 Replies
marcus_sommer

The fileformat mustn't be included within the path - it should be look more like:

FROM [lib://My Date/Filename.qvd] (qvd);

- Marcus

vkish16161
Creator III
Creator III

Try,

FROM [lib://My Date/Filename.qvd] (qvd);

parevrac
Contributor III
Contributor III
Author

brilliant thanks it worked - was the one variation I didn't try

parevrac
Contributor III
Contributor III
Author

brilliant thanks it worked - was the one variation I didn't try