Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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
richard_pressan
Contributor

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

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

2 Replies
erich_shiino
Honored Contributor

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

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

richard_pressan
Contributor

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

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

Community Browser