Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
rob_insley
New Contributor III

Can I retrieve QMC QV Server Settings in a LOAD Script?

I would like to dynamicaly obtain information like Root folder and Looging folder from the QMC Settings so that I do not have to hard code Document Path and Server Information into my load script which will be rolled out on numerous servers.  Is there a way to do this please?

Thanks,

Rob.

Tags (2)
3 Replies

Re: Can I retrieve QMC QV Server Settings in a LOAD Script?

Hi,

For qvd's you can try something like this

let Vpath = 'D:\qvd\';

Test:

LOAD * Inline

[

Field

a

b

c

d

e

];

Store Test into $(Vpath)Test.qvd(qvd);

But I don't think so that you can change Root folder(Document Folder) info from server.

Regards

ASHFAQ

rob_insley
New Contributor III

Re: Can I retrieve QMC QV Server Settings in a LOAD Script?

Sorry for the slow response Ashfaq. And thanks for your reply.  I am aware of the use of a variable but I would like really to obtain the information from the server so I never have to change this has I roll this out across Development / Test / Prod Servers.

Re: Can I retrieve QMC QV Server Settings in a LOAD Script?

Hi

I don't think there is any such universal setting available in server.

There are many different ways but will be similar to the one suggested above.

Edit:

You can use relate path and use same folder structure.

Then you may not need to change anything except connecting strings to database even you can handle that in script.

Regards

ASHFAQ

Community Browser