Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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 - Champion
Partner - Champion

you can use the below statement:

NullAsValue *;

Set NullValue = 'N/A';

shraddha_g
Partner - Master III
Partner - Master III

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

jonathandienst
Partner - Champion III
Partner - Champion III

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.