Surpass null values in chart expressions

[Matt]

Hello,

in chart I want to avoid showing null values at expression level.

My expression look like this

=num(COUNT({<[Bank]={'ING'}>} [Contract ID])/(count(TOTAL [Contract ID])) ,'#,##0.00')

Any help, please?

[Or]

I'm not entirely sure what the question is - suppressing nulls is not related to any specific formula.

To suppress nulls (or 0 values), check the Presentation tab in chart properties (see attached).

[Matt]

The question is, how to display in chart only expressions with not null values.

[Or]

Tick the boxes as explained in my previous post, though iirc the QlikView default should be to suppress nulls.

[Matt]

Unfortunately, this does not work. Still got the null values.

[Or]

Not sure how to help here, then. Perhaps one of your other formulas is returning a non-null value? Suppress nulls doesn't work on a specific expression, it works on an entire row's worth of expressions.