Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
shaunsomai
Contributor
Contributor

Null Values

Hi

Simple Example

I have to tables lets say  Transactions(Contractor and Other Fields)  and Contractors (with Contractor and Region field) which when associated  produces null values as there is no association on the key fields(i.e. Contractor does not appear on the Contractor Table but  does on the transactional table).

When I create a chart object say straight table i want to be able to click on the Regions that are NULL and see the list on Contractors so we can go fix the data on the source.

Any help.

1 Reply
swuehl
MVP
MVP

You can't select NULL in QV by default.

Besides using statements like NullAsValue or a isNull check on field values in your script (please refer to the script), which probably doesn't help here, I would suggest that you use

=concat(Region)

as expression, then make the expression searchable and use an empty search string. This should filter all empty Region (I assume you don't have empty, but not NULL, original Region values, or you might want to check them as well).

Hope this helps,

Stefan