Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Null Values Not Showing

Hi All,

I have a question that should be obvious, but nothing seems to work.  I have a straight table with the following dimensions:

Project_ID

Title

CategoryDesc

Manager

Status

=Date(Start_Time,'MM/DD/YYYY')

=Date(End_Time,'MM/DD/YYYY')

And the following expression:

=Date(End_Time,'MM/DD/YYYY')-Date(Start_Time,'MM/DD/YYYY')

However, there are values in my chart in which start time and end time are null, and these do not show up in the graph.  Suppress Null values is not selected on any of the dimensions. I need all the values to show up, even when there is no start or end time. I tried this for the expression, but it did not work either:

=if(IsNull(Start_Time)=-1,'0',Date(End_Time,'MM/DD/YYYY')-Date(Start_Time,'MM/DD/YYYY'))

If I add another expression like this, all the data shows up:

=If(IsNull(Start_Time)=-1,'Null','Not Null')

Thanks for your help!

11 Replies
whiteline
Master II
Master II

Ok,

Have you unchecked the checkbox 'Supress Zero-Values' on Presentation tab ?

Not applicable
Author

Ha wow. That was ridiculously obvious. Thank you, whiteline and Mayil.