straight table and pivot table

[francofiorillo]

Hello.
is there a way, to not display the NULL "-" symbol from a measure?
is there a way to make the value "0" not appear from a measure?
I would like to display only cells with significant values.
can you help me please?
in QlikView this behavior started quickly.
Thanks in advance

[Vishal_Gupta]

Hi @francofiorillo have you tried using this option for dimensions in your table?

if yes then you might need to write a set expression in measures

[francofiorillo]

hello and thanks for the feedback.
for the dimensions I have already used the option you mention.
for measures what could be the expression that eliminates the NULL value and the MISSING value (in QlikView there was a difference. In Qlik Sense I can't interpret the difference)?

[Or]

Unless something has recently changed, Qlik Sense does not allow replacing the missing value null with a different value in pivot tables, I believe. Some third-party extensions, such as Vizlib Pivot Table, do have the option to set a different null symbol, but the native option does not.

For actual null values (rather than missing value intersections) you can use e.g. Coalesce(FieldName,'0') or whatever other string or field you want to replace the null.

[vikasmahajan · Accepted solution]

Hi ,

In script only you can check 

If( Len(Trim(Field))=0 or Isnull(Field) , this, that) as FieldName

later in set expression you can skip using this field.

Vikas