Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
it's still replace everything to N/A except the null value
Could you please, send us a sample data of your app?
you can use the below statement:
NullAsValue *;
Set NullValue = 'N/A';
Try doing this in Script by using NullAsValue. Refer NullAsValue ‒ Qlik Sense
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.
Jonathan,
What about this?
SET NullDisplay = 'N/A';
Is that right?
Hi,
When I uncheck on the combo list - "Include null values" the value disappear , so it should be null value , no??
Hi,
Thank you for you help , the following expression works:
aggr(if(isnull(NAME),'Other',NAME),NAME)
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.