Qlik Sense App, Null Values issue

[tilakbhawsar094]

Hi All,

I want to select null values in Table but as you all know, there is no such option in qliksense. So, I performed below calculation:

1. Replace it with some value in back end:  If(isnull([Qlik Column Name]),'Empty', [Qlik Column Name]) as [Qlik Column Name];

2. Same above Calculation in front end straight table.

Both the above calculations did not work. It is not even identifying as null.

I have attached a screenshot for more information. Can anyone please help ASAP. 

[AdiPai]

Try this 

If(len([Qlik Column Name]) = 0 ,'Empty', [Qlik Column Name]) as [Qlik Column Name];

[agigliotti]

maybe this:

=If( len(trim([Qlik Column Name])) = 0 or isnull([Qlik Column Name]), 'Empty', [Qlik Column Name] ) as [Qlik Column Name];

[tilakbhawsar094]

It is not even calculating length of that null value. I already tried.

[AdiPai]

can you share the file?

[avkeep01]

Hi @tilakbhawsar094 ,

Just to be sure: there is only on table in where the fields are coming from or is the data coming from multiple tables in your data model?