Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
cliff_clayman
Contributor II

How to suppress null values in an expression

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])

3 Replies

Re: How to suppress null values in an expression

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...

cliff_clayman
Contributor II

Re: How to suppress null values in an expression

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

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