Hi everyone, I’m trying to figure out if it’s possible in Qlik Sense to export a table to Excel by clicking a button, even if that table is hidden from the user or located on a different sheet.
In my app I have two tables:
one for user-friendly data visualization
another “flat” table used only for data export
The idea is that the user clicks something like “Export data” and gets the Excel generated from the “flat” table — without having to see it or switch to another sheet.
Does anyone know if this can be done natively (with standard button actions), or if it requires using APIs or a custom extension?
If you are working within qlik cloud, you could insert in your application a button with the action "Run an Automation"; previously you could create an automation that exports the associated table and insert the automation inside your button.
Please feel free to leave a like to this comment if it helps you out! Federico
I’m not on Qlik Cloud, I’m using Qlik Sense Enterprise.
About the extension part, that’s kinda tricky for me… I work in public administration and our systems are super locked down. I even built my own small extension to export tables through a custom visualization, but it got rejected. So yeah, extensions are a no-go for me.
What I was also wondering is: there any way to export one table that generates an Excel file with multiple sheets?
Any ideas or tips on that would be awesome, thanks! ❤️
