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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Is it possible to create a Business User button to toggle Suppress Zero Values?

Is it possible to create a Business User button to toggle the 'Suppress Zero Values' option for a chart?

1 Reply
Not applicable
Author

yes, but you need to use macro in button trigger

sub Suppress

set obj = ActiveDocument.GetSheetObject("CH01")

set zip = obj.GetProperties

if zip.SuppressZero  = true then zip.SuppressZero  = false else zip.SuppressZero  = true

obj.SetProperties zip

end sub