Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

cancel
Showing results for 
Search instead for 
Did you mean: 
TomBond77
Creator II
Creator II

Suppress 0 values in columns

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

TomBond77_0-1642069595521.png

 

1 Solution

Accepted Solutions
brunobertels
Specialist III
Specialist III

Hi 

in the mesure panel :

condition display column if 

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

brunobertels_0-1642077156953.png

 

View solution in original post

1 Reply
brunobertels
Specialist III
Specialist III

Hi 

in the mesure panel :

condition display column if 

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

brunobertels_0-1642077156953.png