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: 
Not applicable

Suppression of Records

Hi All,

I have a straight table with 6 dimensions and 4 expression calculated field. one of these calculated expression fields is called Bales. I would like to suppress records on the basis of values in Bales field. If the value in the Bales field is 0, then I need that entire record to be suppressed. How can I achieve this.

Thank you

Herbert

2 Replies
chiru_thota
Specialist
Specialist

You can do one thing.For remaining three expression.You can write some thing like below and use second option in the below screen.

It will suppress the unnecessary records for you

If ( Sum(Bales) > 0,Sum(expression1),0)

If ( Sum(Bales) > 0,Sum(expression2),0)

Supress.jpg

maxgro
MVP
MVP

try with

for all (4) expression, set the expression to null when Bale is 0

Expression1          if(sum(Bale)=0,null(),sum(Expression1))

Expression2          if(sum(Bale)=0,null(),sum(Expression2))

....

....

and flag suppress 0 values in presentation tab