This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration on QlikView Management.
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.
Another possibility is to "Select Possibles" in the field, which exclude all NULL values.
View solution in original post
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,