topic Qlik Sense App, Null Values issue in App Development

Qlik Sense App, Null Values issue

tilakbhawsar094 — Sat, 16 Nov 2024 02:26:51 GMT

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 — Thu, 14 May 2020 08:54:52 GMT

Try this

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

agigliotti — Thu, 14 May 2020 09:27:08 GMT

maybe this:

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

tilakbhawsar094 — Thu, 14 May 2020 10:13:46 GMT

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

AdiPai — Thu, 14 May 2020 11:09:36 GMT

can you share the file?

avkeep01 — Thu, 14 May 2020 11:14:02 GMT

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?