Discussion Board for collaboration related to QlikView Deployment.
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.
Go to Solution.
Another possibility is to "Select Possibles" in the field, which exclude all NULL values.
I would create a flag in script.
Let us say that your script is:
Load Invoice, Termination
You can create a flag like this:
Load Invoice, Termination, if( isnull(Termination), ,1,0) as flagDateExists
Then, in a sheet, you can include this field ( flagDateExists) and select one to identify records without termination date
Hope it helps,