If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I have a requirement of exporting a pivot table based on click of a button, I don't want to show this table in my sheets
Can you a bit more clear on the requirement? You don't want to show the table but need table data based on one click?
Yes, I just want to export the table based on one click
The below links is for Show/Hide object.
Qlik Branch (Show/Hide)
Qlik Branch (Export to XL)
You can use a KPI or filters default view and upon it's qlik the Pivot will show. And a Export button will send it to xl.
Or you can also use Ad-Hoc extension to Show/hide the columns
Qlik Branch (Ad-Hoc)