topic Re: How to use Null Values to find missing dates in a field in QlikView https://community.qlik.com/t5/QlikView/How-to-use-Null-Values-to-find-missing-dates-in-a-field/m-p/450647#M1303939 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I would create a flag in script. </P><P>Let us say that your script is: </P><P>Load Invoice, Termination</P><P>From/Resident someTable... </P><P></P><P>You can create a flag like this: </P><P></P><P>Load Invoice, Termination, if( isnull(Termination), ,1,0) as flagDateExists</P><P>From/Resident someTable</P><P></P><P>Then, in a sheet, you can include this field ( flagDateExists) and select one to identify records without termination date</P><P></P><P>Hope it helps, </P><P></P><P>Erich</P></BODY></HTML> Wed, 20 Feb 2013 03:17:24 GMT erichshiino 2013-02-20T03:17:24Z How to use Null Values to find missing dates in a field https://community.qlik.com/t5/QlikView/How-to-use-Null-Values-to-find-missing-dates-in-a-field/m-p/450646#M1303936 <HTML><HEAD></HEAD><BODY><P>I a termiation date in the script I built.&nbsp; What I am wondering if there is a way to find only those records where the termination date has data.&nbsp; </P></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT https://community.qlik.com/t5/QlikView/How-to-use-Null-Values-to-find-missing-dates-in-a-field/m-p/450646#M1303936 2026-01-26T18:19:17Z Re: How to use Null Values to find missing dates in a field https://community.qlik.com/t5/QlikView/How-to-use-Null-Values-to-find-missing-dates-in-a-field/m-p/450647#M1303939 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I would create a flag in script. </P><P>Let us say that your script is: </P><P>Load Invoice, Termination</P><P>From/Resident someTable... </P><P></P><P>You can create a flag like this: </P><P></P><P>Load Invoice, Termination, if( isnull(Termination), ,1,0) as flagDateExists</P><P>From/Resident someTable</P><P></P><P>Then, in a sheet, you can include this field ( flagDateExists) and select one to identify records without termination date</P><P></P><P>Hope it helps, </P><P></P><P>Erich</P></BODY></HTML> Wed, 20 Feb 2013 03:17:24 GMT https://community.qlik.com/t5/QlikView/How-to-use-Null-Values-to-find-missing-dates-in-a-field/m-p/450647#M1303939 erichshiino 2013-02-20T03:17:24Z Re: How to use Null Values to find missing dates in a field https://community.qlik.com/t5/QlikView/How-to-use-Null-Values-to-find-missing-dates-in-a-field/m-p/450648#M1303942 <HTML><HEAD></HEAD><BODY><P>Another possibility is to "Select Possibles" in the field, which exclude all NULL values.</P></BODY></HTML> Wed, 20 Feb 2013 12:23:02 GMT https://community.qlik.com/t5/QlikView/How-to-use-Null-Values-to-find-missing-dates-in-a-field/m-p/450648#M1303942 rlp 2013-02-20T12:23:02Z