topic Re: Null Symbol in App Development

Null Symbol

ali_hijazi — Mon, 20 May 2019 06:37:27 GMT

Hello
I got a pivot table with 4 dimensions and 4 expressions

when no selections or when few selections are made a lot of cells show nulls and you know NULLS are displayed as -
is there a way to change this symbol to blank

this was doable in QlikView; is it doable in Qlik Sense?

Re: Null Symbol

nanda_challa — Mon, 20 May 2019 06:52:50 GMT

Hi Ali,

Try to build logic in script level Saying that if length is zero then replace Space.

Thanks,

Re: Null Symbol

Vegar — Mon, 20 May 2019 06:58:26 GMT

You can manage this by using NullAsValue for your desired fields.

Add script similar to below before loading your data.

NullAsValue FieldA, FieldB, FieldC, FieldD;
Set NullValue = ' ';

Read more: https://help.qlik.com/en-US/sense/February2019/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegularStatements/NullAsValue.htm

Re: Null Symbol

ali_hijazi — Mon, 20 May 2019 07:03:25 GMT

I meant nulls for the measures

I'm not talking about dimensions but rather about a result of of an expression

Re: Null Symbol

ali_hijazi — Mon, 20 May 2019 07:04:00 GMT

it only works when the result of the expression is zero but not when null

Re: Null Symbol

Vegar — Tue, 21 May 2019 06:32:11 GMT

Maybe the alt() function can meet your needs.

=ALT(sum(measure), ' ')

https://help.qlik.com/en-US/sense/April2019/Subsystems/Hub/Content/Sense_Hub/Scripting/ConditionalFunctions/alt.htm