How to make null values in a table chart selectable?

[tahirhasanjafri]

Hi guys,

I have a table chart and there's a categorical column in it which also shows null values when Qlik can't find the relation. The null values don't really exist in the original table. They only exist because of the association between two tables. I want the null values also selectable so I want to put aliases in the place of those null values but can't figure how.

Currently, I have tried this in the specific dimension without success:

if(isnull(['mycolumn']), 'null entry', ['mycolumn'])

Can someone suggest any alternate method?

[MatheusC]

@tahirhasanjafri  And if you leave it as a calculated dimension in a filter for these nulls, like:

=if(isnull([mycolumn]),'[mycolumn] = null')

Att, Matheus

[howdash]

If I understood you correctly, I would recommend creating a column in a table, in the data model, that could be used to select values that are available in one table but don't have associated records in another. Something like this:

Table 1:

Key Field	Data Field	Is Available in Other Table
1	Data 1	Yes
2	Data 2	Yes
3	Data 3	Yes
4	Data 4	No
5	Data 5	No

Other Table:

Key Field	Other Data
1	Other Data 1
2	Other Data 2
3	Other Data 3

This way, you will be able to use the "Is Available in Other Table" field to select any records, the ones that have a value of No, that are available in Table 1, but are missing associated records in Other Table.