Qlik Community

QlikView Administration

Discussion Board for collaboration on QlikView Management.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to use Null Values to find missing dates in a field

I a termiation date in the script I built.  What I am wondering if there is a way to find only those records where the termination date has data. 

1 Solution

Accepted Solutions
rlp
Creator
Creator

Another possibility is to "Select Possibles" in the field, which exclude all NULL values.

View solution in original post

2 Replies
erichshiino
Partner
Partner

Hi,

I would create a flag in script.

Let us say that your script is:

Load Invoice, Termination

From/Resident someTable...

You can create a flag like this:

Load Invoice, Termination, if( isnull(Termination), ,1,0) as flagDateExists

From/Resident someTable

Then, in a sheet, you can include this field ( flagDateExists) and select one to identify records without termination date

Hope it helps,

Erich

rlp
Creator
Creator

Another possibility is to "Select Possibles" in the field, which exclude all NULL values.