Null Symbol

[ali_hijazi]

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?

[nanda_challa]

Hi Ali,

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

Thanks,

[Vegar]

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/ScriptRegu...

[ali_hijazi]

I meant nulls for the measures

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

[ali_hijazi]

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

[Vegar]

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/ConditionalFu...