topic Null object display in App Development

Null object display

Luis — Sat, 16 Nov 2024 05:31:54 GMT

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 — Thu, 20 Jun 2019 21:00:20 GMT

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 — Thu, 20 Jun 2019 21:11:33 GMT

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

Luis — Fri, 21 Jun 2019 07:59:33 GMT

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?