Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
MarcoARaymundo
Creator III
Creator III

How to hide column is the total of this column is zero

Hi!

Any idea?

Thanks

Marco

4 Replies
MayilVahanan

HI

Try with

Enable condition

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Anonymous
Not applicable

Hi Marco,

You could use the Enable condition or use a conditional in the expression. column:

You must aggregate the column of the total to archieve this. As in:

Using Enable condition:

Aggr( Sum ( Value ), YourColumn  )  > 0

Using the expression. column:

If( Aggr( Sum ( Value ), YourColumn  )  > 0, Value, 0 )

Hope I could help

Regards

Not applicable

Surpress When Value is Null?

Peter_Cammaert
Partner - Champion III
Partner - Champion III

Try this:


Conditional show without aggr().

Peter