topic How to suppress null values in an expression in QlikView

How to suppress null values in an expression

cliff_clayman — Thu, 16 Jun 2016 15:41:20 GMT

I have an expression that produces some null values that I do not want to see. I know there is an option to suppress nulls in a dimension, but how can I do it in the following expression:

=If(WildMatch([VendorNum], 'TRA*'),[VendorNum])

Re: How to suppress null values in an expression

sunny_talwar — Thu, 16 Jun 2016 15:54:41 GMT

Are there more than one expression in your table? If there is a value available for those expression, then you will continue to see this expression's value as null. to suppress it, all other expressions will have to be manually suppressed by using if statement:

If(WildMatch([VendorNum], 'TRA*'), YourExpression1)

If(WildMatch([VendorNum], 'TRA*'), YourExpression2)

...

and so on...

Re: How to suppress null values in an expression

cliff_clayman — Thu, 16 Jun 2016 15:56:37 GMT

Yes, there are two other expressions in this particular straight table. I'm not sure I follow your answer though in regards to how I should write each expression. The other two expressions are just simple SUMs.

Re: How to suppress null values in an expression

sunny_talwar — Thu, 16 Jun 2016 16:28:41 GMT

Like this:

1) =If(WildMatch([VendorNum], 'TRA*'),[VendorNum]))

2) =If(WildMatch([VendorNum], 'TRA*'), Sum(FieldName1))

3) =If(WildMatch([VendorNum], 'TRA*'), Sum(FieldName2))

Assuming you are summing FieldName1 and FieldName2 in your two other expressions