Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Explain this syntax?

Hi,

ISNULL(Fieldname) <> -1   means what?


1 Solution

Accepted Solutions
luciancotea
Specialist
Specialist

ISNULL(Fieldname) <> -1

ISNULL(Fieldname) <> TRUE()

ISNULL(Fieldname) = FALSE()

NOT ISNULL(Fieldname)

Means if Fieldname is not null

View solution in original post

3 Replies
luciancotea
Specialist
Specialist

ISNULL(Fieldname) <> -1

ISNULL(Fieldname) <> TRUE()

ISNULL(Fieldname) = FALSE()

NOT ISNULL(Fieldname)

Means if Fieldname is not null

Peter_Cammaert
Partner - Champion III
Partner - Champion III

-1 corresponds to the value true.

The expression equals:

IsNull(FiueldName) <> true()

Not applicable
Author

Take text-box & put =ISNULL(Fieldname)

If result is -1 then it states field contains Null values else if returned result is 0 then not null..