Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Show/Hide Subtotal in Pivot Table

Hello,

I am using a pivot table for report with10 columns in dimensions. At present I am showing subtotal for Columns 1 to 5. When user view report in Internet Explorer they need to have an option to show or hide sub total for columns they want. Is that thing possible using script or macro where user can turn on / off display partial total?

Thanks in advance.

Regards,

3 Replies
Not applicable
Author

Hi

Duplicate the table and add a button "Show/Hide Subtotal"

Add a trigger on the button which change a variable. Use this variable to show or not the table with subtotal

Hope that helps

Not applicable
Author

Thanks for the quick response. I am not so much familiar with using trigger. I would appreciate if you can send me sample or script I need to add in macro.

Regards,

Not applicable
Author

Done!