Null object display

[Luis]

Hi,

In Qliksense if you a have a Null in a visualisation it is shown as a ' - '.

In QlikView you could change it directly in the objet like this: 

Is it possible to do something like that in QlikSense, in the object or maybe by script giving some default value?

Thank you

[Vegar]

You should look into the NullAsValue command in Qlik Sense/QlikView. It is done in the script and could look like this.

Example:  
NullAsValue A,B;
Set NullValue = 'NULL';
LOAD A,B from x.csv;

Read more on the topic here:  NullAsValue - Qlik Sense 

[Wlad_Masi]

There is a feature request created to our R&D team, requesting for this feature.
The feature request ID is 1031.

[Luis]

Hi,

This is simmilar to do If( Isnull(A), 'NULL') right?

But the problem is when I make a Sum(A) and they are all 'NULL' it put 0 not 'NULL'.

The problem too is that Sum(Null())= 0 but i solve it doing Sum(A) * Count(A)/ Count(A) someone knows a better way?