Discussion board where members can learn more about Qlik Sense App Development and Usage.
HelloI 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?
Try to build logic in script level Saying that if length is zero then replace Space.
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...
I meant nulls for the measures
I'm not talking about dimensions but rather about a result of of an expression
it only works when the result of the expression is zero but not when null