topic Re: LOAD statement only works with lib:// in QlikView

LOAD statement only works with lib://

Thu, 10 Nov 2016 15:28:21 GMT

I have made script in QVW

Selectie:

LOAD %Eigenaar_ID,

%Contract_ID,

%Complex_ID,

%Rondecode_ID

FROM D:\Eucebia\04_QVD\Dimensies\_Selectie.qvd](qvd)

Where %Rondecode_ID = 'AVG';

Now I want to use this in Qlik Sence now I get this message

LOAD statement only works with lib:// paths in this script mode

How can i adhust this?

Re: LOAD statement only works with lib://

Chanty4u — Fri, 11 Nov 2016 06:00:56 GMT

is it Qlikview/Qliksnse?

Re: LOAD statement only works with lib://

jonathandienst — Fri, 11 Nov 2016 06:34:24 GMT

You need to add the data source to the Sense data load editor. This will create a lib:// entry for your load.

Re: LOAD statement only works with lib://

kedar_dandekar — Fri, 11 Nov 2016 07:12:35 GMT

For quick testing of your QlikView scripts, you can disable standard mode, or in other words, enable legacy mode.

This mode will help you reuse the QlikView load scripts that uses absolute path(s).

In addition to the absolute path the legacy mode also supports use of relative file paths as well as library connections in QlikSense.

Refer qlik help: https://help.qlik.com/en-US/sense/3.0/Subsystems/Hub/Content/LoadData/disable-standard-mode.htm

- KD

Re: LOAD statement only works with lib://

Anonymous — Fri, 11 Nov 2016 07:23:07 GMT

Hi Marc,

Please follow below steps and avoid the above error

1. Create New Connection (You can see right side of script)

2. Once done the connection , you can see one option in the below of the connection like (insert connection string) click on that you will get the connection in the script like

LIB CONNECT TO 'TD DEV';

after that go to create connection , from that you can see folder click on that wherever you want save your Qvd , you can check and create qvdfolder