Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. 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