topic Accessing a Directory in QlikView

Accessing a Directory

sagar_vij99 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have a requirement where i have to attach more than 20 excel files in my dashboard. I tried a solution, i created a folder structure on server. One folder for every team then each folder month wise sub folders as i will receive these files on monthly basis.

In my dashboard, i created 7 buttons for each such folder as i want my client to go in main folder and then select any month's folder and access the files in it.

Now the problem is it works on my local machine and as soon as i deploy it on server, it does not work.

can anyone help out here..? Or any suggestion how it can be done some other way..??

Thanks..!!

Re: Accessing a Directory

anushree1 — Thu, 16 May 2019 09:49:44 GMT

I assume it is the issue with the Folder path, please check the folder structure on server where its deployed also ensure using relative paths

Re: Accessing a Directory

Brett_Bleess — Tue, 25 Jun 2019 21:32:05 GMT

What if you used variables instead and put the paths in each variable, and you could use the wildcard piece from the link below as well I think, just an idea, might be simpler, so the variable would go into your From statement etc. If I have misunderstood what you are doing, sorry, but hopefully this may give you some further ideas.

https://community.qlik.com/t5/Qlik-Design-Blog/Wildcard-data-loading-blah/ba-p/1467768

Regards,
Brett