Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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