select in field action in qlikview

[prasoon92]

I have requirement where some of the Jobs have status NULL. i need to filter out these but the select in field is not working on the null values. Anything else can be done here?

[Anonymous · Accepted solution]

okay, I understood

the your script is okay, but I am confused about your exists. Do you get an error?

because the right Parameter %tempkey2 does not exist in your source table and will be created

I would expect

where not exists(%tempkey, Jname&'|' &Odate)

[prasoon92]

It worked! Thanks man