Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Creator
Creator

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

Highlighted
Specialist III
Specialist III

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

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

you can use the below statement:

NullAsValue *;

Set NullValue = 'N/A';

Highlighted
Partner
Partner

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

Highlighted

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
Highlighted
Specialist III
Specialist III

Jonathan,

What about this?

SET NullDisplay = 'N/A';

Is that right?

Thiago Justen Teixeira Gonçalves
WhatsApp: 24 98152-1675
Skype: justen.thiago
Highlighted
Creator
Creator

Hi,

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

Highlighted
Creator
Creator

Hi,

Thank you for you help , the following expression works:

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

View solution in original post

Highlighted
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.