Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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)?
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.
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