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
You'd need to add Dim/Measures to Master items and it will give you a On/Off switch for this extension, in that way you do not have too many columns as your default view but only important one's while you can export it to xl.
Hi and thanks for your support! I've tried everything, but only the show/hide object works. The export doesn't work and the Ad-Hoc extension works only with tables, not with Pivot tables.
I solved by reducing the size of the pivot table in order to show only title and subtitile and it can be exported to Excel by using the buil-in export command that appears when you right click on it.
The Export to XL will work on server only. Not on desktop, even I had same problem but when you publish the app on server by providing the Object ID, you can.
Ad-Hoc will also work with Pivot. It's working for me, just tested.
Get your Object id from http://localhost:4848/dev-hub/single-configurator and enter it manually in Ad-Hoc extension.
That link for Ad Hoc also have an example App.