Suppress 0 values in columns

[TomBond77]

Hi experts

We need to suppress 0 value columns, here is an example for a measure and a screen if you filter on a division, some columns give 0 value. These columns need to be suppressed. How does it work in Qlik Sense?

Sum({$ <table.Division *={'100'}>} amount) / -1000

[brunobertels · Accepted solution]

Hi 

in the mesure panel :

condition display column if 

if(yourmesure=0,0,1) or reverse values if(yourmesure=0,1,0)