Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
WE ARE LISTENING! New Navigation for Qlik Community, Sept. 26: TELL ME MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Store QVD Files using a variable with the path

Hi,

I have problems with my script when I'm using a path variable which is set in an ini-file and the path is UNC path.

I will receive a general script error.

When I type the UNC-path dircectly into the script it will work.

Ini-File:

Set DataHome = "\\FSCL01\Prg-Web-Kredit\temp\rpe\N\Recht\";

Let DataPathQVD_TGL = '$(DataPathRoot)Datenquellen\QVD_aktuell\';

Script:

store Foberedaten into $(DataPathQVD_TGL)Foberedaten.qvd; --this is not working

store Foberedaten into \\FSCL01\Prg-Web-Kredit\Temp\rpe\N\Recht\GOBS\Datenquellen\QVD_aktuell\Forderungsdaten.qvd; --this works

There are many files in the script and I don't want to change every single tab.

Question: What is wrong with my script?

Thanks a lot in advance for some help.

8 Replies
amartinez35
Partner - Specialist
Partner - Specialist

Hi,

If you try

Set DataHome = \\FSCL01\Prg-Web-Kredit\temp\rpe\N\Recht\;

(without ")


Aurélien

Help users find answers! Don't forget to mark a solution that worked for you!
undergrinder
Specialist II
Specialist II

Hi Roswitha,

Try this:

set DataHome   = 'DataHome - with quotation marks, it should be a lib connect like lib://example';

set DataPathQVD_TGL = 'lib://$(DataHome)/Other_path'; //With quotation mark, and set

STORE TableName  INTO '$(DataPathQVD_TGL)\TableName.qvd'  (qvd);

It should work.

G.

Not applicable
Author

Sorry this doesn't work

Not applicable
Author

Thanks, I found the problem, one of the directory names were wrong.

undergrinder
Specialist II
Specialist II

I copied it from one of my production code, what is the error message you get?

Not applicable
Author

thanks, it is working as you described.

rnt
Employee
Employee

Can you try this, enclosing it in brackets?

store Foberedaten into [$(DataPathQVD_TGL)Foberedaten.qvd];

gompa786
Creator III
Creator III

Hi,

Below is my code and it works in  Qliksense.

Qlikaccess :
LOAD
    "Comm_Per 1",
    "Comm_Per 2",
    "Comm_Per 3",
    "Comm_Per 4",
    CostCentre,
    "Comm_Per 5",
    "Access 1",
    "Access 2",
    OPD,
    "Access 3",
    OPD1,
    "Access 4",
    OPD2
FROM [lib://Files (opd_f29121)/Copy of Qliksense Access (3).xlsx]
(ooxml, embedded labels, table is Sheet1);


store Qlikaccess into [lib://Raw_qvd (opd_f29121)/$(x)Qlikaccess_Test_13.qvd];

DataPathQVD_TGL = '$(DataPathRoot)Datenquellen\QVD_aktuell\';

can you please remove the quotes from the path

DataPathQVD_TGL = $(DataPathRoot)Datenquellen\QVD_aktuell\;

and try

[$(DataPathQVD_TGL)Foberedaten.qvd];

Thanks