Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

parevrac
New Contributor

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

Re: Syntax for FROM statement to load from existing QVD

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

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

- Marcus

Highlighted
vkish16161
Contributor III

Re: Syntax for FROM statement to load from existing QVD

Try,

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

parevrac
New Contributor

Re: Syntax for FROM statement to load from existing QVD

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

parevrac
New Contributor

Re: Syntax for FROM statement to load from existing QVD

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