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: 
Luis
Partner - Contributor
Partner - Contributor

Null object display

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: 

image.png

 

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

image.png

 

Thank you

Labels (1)
3 Replies
Vegar
MVP
MVP

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
Employee
Employee

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

To help users find verified answers, please don't forget to mark a correct resolution or answer to your problem or question as correct.
Luis
Partner - Contributor
Partner - Contributor
Author

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?