Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.