Using Where [Field] is not null not working in qlik sense

[thakurdagautam]

I am trying to restrict a field where i can only load not null values. When i am doing so, i get IS in red color. How do i rectify this?

[Gysbert_Wassenaar · Accepted solution]

Yeah, Qlik script is not SQL.

Try this: Where not IsNull(IsProcessedByAO).

Or this: Where Len(Trim(IsProcessedByAO))>0