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: 
ali_hijazi
Partner - Master II
Partner - Master II

Null Symbol

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?

I can walk on water when it freezes
5 Replies
nanda_challa
Contributor
Contributor

Hi Ali,

 

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

 

 

Thanks,

Vegar
MVP
MVP

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
Partner - Master II
Partner - Master II
Author

I meant nulls for the measures

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

I can walk on water when it freezes
ali_hijazi
Partner - Master II
Partner - Master II
Author

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

I can walk on water when it freezes
Vegar
MVP
MVP