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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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..