Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
RutiTaumanRubin
Creator
Creator

How to replace null() by value - Qliksense

Hi ,

I create a table in qliksense,

I want to replace the value null to 'N/A' in each field.

I used in the following expression , but it doesn't replace to the value , and stay null:

=if(IsNUll(NAME), 'NA', NAME)

Could you please advice?

Thank's!

18 Replies
RutiTaumanRubin
Creator
Creator
Author

it's still replace everything to N/A except the null value

Thiago_Justen_

Could you please, send us a sample data of your app?

Thiago Justen Teixeira Gonçalves
Farol BI
WhatsApp: 24 98152-1675
Skype: justen.thiago
agigliotti
Partner
Partner

you can use the below statement:

NullAsValue *;

Set NullValue = 'N/A';

shraddha_g
Partner
Partner

Try doing this in Script by using NullAsValue. Refer NullAsValue ‒ Qlik Sense

jonathandienst
Partner
Partner

It looks like these values are not nulls - they are missing values. Missing values are never evaluated, so it does not matter what expression you use. NullasValue also will not help you - this is a data model design issue, and you will need to provide details of your data sources, expressions and load scripts (and a small sample qvf).

And for the record, Alt() is not intended to catch nulls. Rather it returns the first valid numeric value in its list of arguments. So it filters non-numerics (eg invalid dates) and cannot be used to filter nulls for a text field.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Thiago_Justen_

Jonathan,

What about this?

SET NullDisplay = 'N/A';

Is that right?

Thiago Justen Teixeira Gonçalves
Farol BI
WhatsApp: 24 98152-1675
Skype: justen.thiago
RutiTaumanRubin
Creator
Creator
Author

Hi,

When I uncheck on the combo list - "Include null values" the value disappear , so it should be null value , no??

RutiTaumanRubin
Creator
Creator
Author

Hi,

Thank you for you help , the following expression works:

aggr(if(isnull(NAME),'Other',NAME),NAME)

Vineet_Chauhan
Contributor
Contributor

Thank you the solution works in displaying the 'NA' or any other title, however, it cannot be selected in the table. Can we make that possible.