Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
Matt
Contributor III
Contributor III

Surpass null values in chart expressions

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?

 

5 Replies
Or
Master
Master

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
Contributor III
Contributor III
Author

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

Or
Master
Master

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

Matt
Contributor III
Contributor III
Author

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

 

Or
Master
Master

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.