Include null Values rows even after selection

[SMT]

Hello, when I select a filter from the dimension, the rows containing null values disappear. Instead, it should display both the rows with null values and the rows matching the selected values from the same column.

[avinashelite]

For this you need to convert the "null" values as a select able string value in the filter by assigning the value in script , and then need to handle in the expression to include null values , else it will not show up .

Qlik by default always shows the values selected 

[vighnesh_gawad]

Hi @SMT , reason you cant select null values because those doesn't exit in data model.  So you need to assign values to it. Depending upon scenario it can be handle in multiple ways in Qlik sense. Using qlik load script or expression you can convert those null values in blank values which can be selected later by qlik sense filter. 

Check out below article on many ways you can handle null in Qlik sense. 

https://help.qlik.com/en-US/sense/November2025/Subsystems/Hub/Content/Sense_Hub/Scripting/null-value...

[Chanty4u]

Hi try this in dimension.=Alt(DimensionField,'Null')

Or may be with below 

=If(IsNull(DimensionField),'Null',DimensionField)

If you want in script you can do this 

LOAD

If(IsNull(DimensionField),'Null',DimensionField) as DimensionField

FROM source;