Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
Partner
Partner

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
Highlighted
New Contributor

Re: Null Symbol

Hi Ali,

 

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

 

 

Thanks,

Highlighted
Partner
Partner

Re: Null Symbol

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

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
Highlighted
Partner
Partner

Re: Null Symbol

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
Highlighted
Partner
Partner

Re: Null Symbol

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

I can walk on water when it freezes
Highlighted
Partner
Partner

Re: Null Symbol

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...
Plees ekskuse my Swenglish and or Norweglish spelling misstakes