topic Re: Automating a data download from Qlik in Connectivity & Data Prep

Automating a data download from Qlik

MaheshSurendran — Tue, 07 Apr 2026 18:13:07 GMT

Hi,

I am wondering if someone can point me to automating a download from Qlik. Any help would be appreciated.

Mahesh Surendran

Re: Automating a data download from Qlik

marksouzacosta — Wed, 08 Apr 2026 06:01:47 GMT

I need more details of what you are trying to do. Are you thinking about moving a QVD file from Qlik Cloud to an on-prem machine?

Regards,

Mark Costa

Re: Automating a data download from Qlik

MaheshSurendran — Wed, 08 Apr 2026 14:12:30 GMT

Hi Mark,

I really appreciate your reply. Could you please tell me something about yourself? Do you work for Qlik?

I am not sure I am trying to download a Qlik QVD file. We could get on a Teams Chat and I could screen share what I am trying to do.

I am not sure we have the Cloud version of Qlik. I will try and find out.

Usually we right click and ask to download a Qlik data set which in turn queries some other data environment. Once it is ready for download, we then download it. It is tedious to repeat this multiple times for multiple Qlik datasets.

So I am wondering if there is a way to automate this so we do not have to download data multiple times from Qlik.

Mahesh Surendran

Re: Automating a data download from Qlik

hugo_andrade — Wed, 08 Apr 2026 16:04:22 GMT

Hi @MaheshSurendran,

Yes, this can usually be automated.

If the goal is to save the data somewhere instead of manually right clicking and downloading it each time, a cleaner approach is to write the file during the app reload itself.

You can create a data connection to the destination where you want the file to be saved, then use the Store command in the load script to write the file directly there. That way, every time the app reloads, it can generate the output file automatically.

So instead of treating Qlik as a place where a user manually exports data, you let the reload process create the file for you.

This is especially useful if:

the export always follows the same logic
the output needs to go to a known folder or location
you want the process to run on a schedule without user interaction

The main thing to confirm is what the destination is. For example:

a folder location
SharePoint
S3
another connected storage target

Once that part is clear, the next step is usually to set up the right data connection and then store the final table there as part of the reload.

Super powerful approach, and usually much more reliable than trying to automate a manual UI download.

Hope this helps.

Please give it a like, mark it as Helpful or Solution if that was the case.

Re: Automating a data download from Qlik

MaheshSurendran — Wed, 08 Apr 2026 18:28:56 GMT

Hi Hugo,

Thanks for your message and suggesting the way forward.

However, I am new to creating data connections and to using the STORE command in the load script. Are you able to walk me through these steps or suggest something I could read?

Mahesh Surendran

Re: Automating a data download from Qlik

hugo_andrade — Wed, 08 Apr 2026 18:34:01 GMT

Would Sharepoint/Onedrive be a valid option for you to store these files?

I believe I have a working example

Re: Automating a data download from Qlik

MaheshSurendran — Wed, 08 Apr 2026 19:06:57 GMT

Hi Hugo,

By OneDrive do you mean a folder such as C:\Users\xxxx\OneDrive - Santander Office 365\xxxx\?

Could you please send me the example? Thanks so much for your help.

Mahesh

Re: Automating a data download from Qlik

hugo_andrade — Wed, 08 Apr 2026 19:27:14 GMT

@MaheshSurendran ,

A good way to handle it is to create a data connection to the destination, for example SharePoint or OneDrive, and then use the script to store the output file there during the app reload. That way, Qlik generates the file for you instead of manually download it each time.

So the general flow would be:

connect to the target location,
prepare the table in the script,
then use the Store command to dump the data out to that connection.

The main questions I would check first are:

Do you have access to create a new data connection in your environment?
Are you on Qlik Cloud, Qlik Sense, or QlikView?

Re: Automating a data download from Qlik

MaheshSurendran — Wed, 08 Apr 2026 19:55:37 GMT

Hi Hugo,

I can create a data connection.

Here is the information I have on Qlik:

Is this sufficient?

Mahesh

Re: Automating a data download from Qlik

MaheshSurendran — Wed, 08 Apr 2026 19:59:26 GMT

Hi Hugo,

In the data load editor I can create a new connection and I get the following screen:

Mahesh

Re: Automating a data download from Qlik

hugo_andrade — Wed, 08 Apr 2026 20:41:07 GMT

@MaheshSurendran ,

This is good information.

It is simpler now. You should be able to create a folder connection as well, but that's not available for you based on the screenshot.

You will have to request your Qlik Sense Administrator to create a security rule to allow you to create a folder data connection.

That way, you will be able to finally drop the file automatically on the network upon reload.

Ping me when you have completed this step, ok?

Check below the difference between your screenshot and mine.

Re: Automating a data download from Qlik

MaheshSurendran — Thu, 09 Apr 2026 11:52:34 GMT

Hi Hugo,

I have contacted the Qlik folks in the company asked if they could allow me to create a folder data connection. Let us wait to see how that works out.

Thanks again.

Mahesh

Re: Automating a data download from Qlik

hugo_andrade — Thu, 09 Apr 2026 13:36:23 GMT

@MaheshSurendran , the idea is to allow you to be able to create the folder connection. Then you will need to update the script and include a STORE command.

Let me share the reference for that command as well: https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegularStatements/Store.htm

Re: Automating a data download from Qlik

MaheshSurendran — Mon, 13 Apr 2026 20:42:53 GMT

Hi Hugo,

Our administrator informed me that it is not possible to create a folder data connection. Is there any other solution you can think of?

Mahesh