Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Wolfmeyn
Contributor
Contributor

How to filter on blank values in table

I have created a qlik report sheet which is a table.

In this table(picture attached) i have some blank values but i cant filter on them, how can i make them as "Null" or something else which i then can filter on in the table. 

Labels (4)
1 Reply
hic
Former Employee
Former Employee

NULLs are not selectable. So it is NOT possible to select them (filter on them).

You could in the script do something like

If(IsNull(Field),'NULL',Field) as Field

and then the Field will become selectable. But that will not cover all cases. You will still sometimes get what you see in your picture. For example, if a key exists in one table but is missing in another. 

See more on https://community.qlik.com/t5/Design/Finding-NULL/ba-p/1474279. The article is about QlikView, but you have the same behaviour and functionality in Qlik Sense.