topic Re: Variable Path for load script in QlikView

Variable Path for load script

Anonymous — Tue, 17 Nov 2015 21:28:00 GMT

Hi All,

I want to know if its possible to have an INPUT BOX with a variable path value that I can use in the load script. What I want to accomplish is to have an Inputbox where user can have the ability to change the file name and path. Instead they have to change in the load script. For example: I want input box to replace below " ".

LOAD *
FROM

(ooxml, embedded labels, table is [sheet1]);

Many Thanks,

Frank

Re: Variable Path for load script

sunny_talwar — Tue, 17 Nov 2015 21:30:43 GMT

Yes you can. Create a variable, say vPath

vPath = H:\user1\abc.xlsx

LOAD *

FROM

[$(vPath)]

(ooxml, embedded labels, table is [sheet1]);

Re: Variable Path for load script

tamilarasu — Wed, 18 Nov 2015 01:40:36 GMT

Hi Frank,

Check the attachment and let me know.

Re: Variable Path for load script

Anonymous — Wed, 18 Nov 2015 01:43:12 GMT

It's works. Thank You Sunny!

Re: Variable Path for load script

Anonymous — Wed, 18 Nov 2015 01:48:22 GMT

Thanks Tamil. Your suggestion works as well..

Re: Variable Path for load script

qlikpahadi07 — Wed, 18 Nov 2015 04:10:04 GMT

Hi Fanko1225

Above solution from Sunny will work from Developer machine but correct me if I am wrong. you need to

"have an Inputbox where user can have the ability to change the file name "

For This I assume you might want to provide this flexibility to Business Users on Access point if yes then it will not work. but for any developer " yes it will work".

Might be Helpful

Re: Variable Path for load script

tamilarasu — Wed, 18 Nov 2015 04:41:17 GMT

Check my solution for business users as well as developers.

Re: Variable Path for load script

qlikpahadi07 — Wed, 18 Nov 2015 05:39:32 GMT

I don't think for Business users through access point your will work.

Re: Variable Path for load script

tamilarasu — Wed, 18 Nov 2015 05:45:56 GMT

I have not tested in access point.

Re: Variable Path for load script

qlikpahadi07 — Wed, 18 Nov 2015 05:53:50 GMT

As per my knowledge It will not work as Qlik Architecture. that is a reason I highlighted

Re: Variable Path for load script

tamilarasu — Wed, 18 Nov 2015 05:56:57 GMT

Thanks for the update. I just shared my applications with users and works well for them. I didn't get a requirement / chance to test this in access point.

Re: Variable Path for load script

Anonymous — Thu, 19 Nov 2015 17:31:46 GMT

Good to know.. I didn't test it out in access point. thanks