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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
ambasadorknz
Contributor II
Contributor II

Work with null

Hello,

How you exclude and include null value?

Example inclose.

@ !

1 Solution

Accepted Solutions
Miguel_Angel_Baeyens

What do you want to see exactly? Null values are not selectable nor you can exclude them from an expression (e.g.: set analysis) as they do not exist.

If those nulls come from the data and you don't need those lines for your analysis, use a JOIN function in the script so all fields are populated.

View solution in original post

1 Reply
Miguel_Angel_Baeyens

What do you want to see exactly? Null values are not selectable nor you can exclude them from an expression (e.g.: set analysis) as they do not exist.

If those nulls come from the data and you don't need those lines for your analysis, use a JOIN function in the script so all fields are populated.