Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi
in the mesure panel :
condition display column if
if(yourmesure=0,0,1) or reverse values if(yourmesure=0,1,0)
Hi
in the mesure panel :
condition display column if
if(yourmesure=0,0,1) or reverse values if(yourmesure=0,1,0)