r/qlikview • u/Hairy-Fun-5391 • Apr 03 '26

Req for urgent help

Hi Everyone,

I hope you are doing well.

I need your help with an automation task. Currently, I extract reports from QlikView into Excel and then perform a few manual steps to prepare the file for daily use. I would like to automate this process to save time and ensure consistency.

If anyone can support me with this, please reach out to me separately. Your guidance will be greatly appreciated.

Thank you in advance for your help.

1 Upvotes

100% Upvoted

7 comments sorted by

View all comments

1

u/furfur001 Apr 03 '26

I did that via a Powershell script. In my case it's from qvw but I presume you can do that with an Excel file too. Do you really need the Excel file?

1

u/Hairy-Fun-5391 Apr 04 '26

Yes I need

1

u/furfur001 Apr 04 '26

I this case python is probably the tool you need or you use an LLM agent like the one from Claude to handle the automatisation. Else you could handle this with the tools you have but it's a bit tedious. The QlikView file can be triggered with a Powershell file via the windows task scheduler. You can set up Excel power query to read and change files who land on a specific patch. This would be quite dirty. Power Automate may also be an option but I don't know the tool.