Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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).
The question is, how to display in chart only expressions with not null values.
Tick the boxes as explained in my previous post, though iirc the QlikView default should be to suppress nulls.
Unfortunately, this does not work. Still got the null values.
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.