topic Re: Surpass null values in chart expressions in QlikView

Surpass null values in chart expressions

Matt — Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: Surpass null values in chart expressions

Or — Thu, 14 Mar 2019 15:02:36 GMT

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

Re: Surpass null values in chart expressions

Matt — Fri, 15 Mar 2019 09:19:21 GMT

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

Re: Surpass null values in chart expressions

Or — Sun, 17 Mar 2019 13:25:36 GMT

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

Re: Surpass null values in chart expressions

Matt — Mon, 18 Mar 2019 07:56:47 GMT

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

Re: Surpass null values in chart expressions

Or — Tue, 19 Mar 2019 09:14:49 GMT

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.