topic Re: Share Folder in QlikView

Share Folder

Seb_seb — Mon, 26 Jan 2026 21:26:37 GMT

Hi,

Hi want load data in an excel files in a share folder, but i doesn't want to use the user services account in the share folder permission.

It's possible ?

thanks

Re: Share Folder

Chip_Matejowsky — Wed, 14 Jul 2021 15:15:36 GMT

Hi @Seb_seb,

You want to load data from an .xlsx file located in a shared folder, but the QlikView service account doesn't have permissions to access the folder/file? Is this a standard Windows shared folder or a SharePoint folder? Are you not able to grant the service account permissions to the folder?

Best Regards

Re: Share Folder

Seb_seb — Thu, 15 Jul 2021 07:20:08 GMT

Hi,

This is a standard windows shared folder.

But I am looking for a solution not to use the service account but another account because my rssi does not want us to use this account to access these files for security reasons

There is a way for this ?

Thanks

Re: Share Folder

Chip_Matejowsky — Thu, 15 Jul 2021 19:06:58 GMT

Hi @Seb_seb,

I'm not aware of any method of doing what you're asking about within the QlikView document's load script. It may be possible to load data this way via a .bat file using runas command or something similar. A traditional QVW loadscript would require the service account to have permissions to the directory. Good luck.

Best Regards

Re: Share Folder

Seb_seb — Fri, 16 Jul 2021 07:23:30 GMT

Hi,

thank you all the same for the help

Re: Share Folder

Windighost — Mon, 19 Jul 2021 10:18:36 GMT

@Chip_Matejowsky wrote: great people me
Hi @Seb_seb,
I'm not aware of any method of doing what you're asking about within the QlikView document's load script. It may be possible to load data this way via a .bat file using runas command or something similar. A traditional QVW loadscript would require the service account to have permissions to the directory. Good luck.

Best Regards

Your content helped me a lot to take my doubts, thank you very much.

Re: Share Folder

marcus_sommer — Fri, 16 Jul 2021 10:49:23 GMT

In general it's possible to use an EXECUTE statement to trigger a batch or maybe a windows-task with another user which used the desktop client to load these data. But it's not trivial to get it to work because a lot of conditions in regard to QlikView and Windows installation/licencing/configurations must be fulfilled and there are not much respectively meaningful error-messages to find the reasons why something didn't work. Beside this a functional solution/workaround may also collide with certain security rules from your company.

IMO better would be to create a special (network) share to exchange the data. Means a place where the Qlik admin and your user or any other relevant user have access. And then a windows task which starts all n times a robocopy-batch to synchronize the data. Benefits would be you could remain by the standard qmc load-workflow without touching the origin access-rights because now it's a push to Qlik and not a pull from Qlik. Further by larger datasets an additionally copy-job could be added in beforehand of the origin load to load not from a network else from a local storage (depends on your environment if this is a real benefit or rather not).

- Marcus