Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Not null

what is the syntax for checking not null condition

thanks in advance

5 Replies
tresesco
MVP
MVP

If( Not IsNull(YourField/Expression), 'Not Null', 'Null')

pierre_fr
Contributor
Contributor

Hi,

and sometimes (especially with flat files), it might be required to add ... and trim(Field)<>''

Regards

maxgro
MVP
MVP

not isnull(field)

or

len(trim(field)) > 0

walterlh
Creator II
Creator II

No IsNull(Campo)

mohamed_ahid
Partner
Partner

hi

isnull(field)=0