Automatic download at the end of the month

[ValeriaBonini]

Hi, I have a dashboard with an extension button that downloads an excel with a lot of datas 

I would like to have an automatic download every last day of the month, and each file should go in a folder (export_folder) and have a name like "export_dd/mm/yyyy"    (export_31/12/2023) 

Is there a solution for this?

[sbaro_bd]

Hi @ValeriaBonini ,

Not possible to do an automatic extract on front-end, only in backend! So you have to use the STORE() function in the script load editor. If you use Qlik Sense server version (or Cloud version), you plan an automatic task on QMC to perform this extraction/storage monthly.

Regards.

[Or]

You could do something of this nature using either NPrinting (Enterprise) or presumably Automation (Cloud). It would not be using your button, though - you'd need to set things up specifically for that.

 You could also use non-Qlik tools to set up an automated sequence of clicks on a computer, and schedule that using Windows scheduling or other scheduling software. You could then record a macro that opens your dashboard and clicks the location of the button, scheduled to run as required.