Export Button for Pivot table in Qlik Sense

[vishus913]

Hi All,

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 

[shiveshsingh]

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?

[vishus913]

Yes, I just want to export the table based on one click

[shiveshsingh]

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)