Rename Null value in chart

[Alarkis]

I got chart that uses 2  different expressions together and the null dimension is from the second expression and i want to rename from null to something else.

Chart:

Currently used expression for dimension:

=if(IsNull(TYPE),'Test',TYPE)

[MayilVahanan]

Hi @Alarkis 

Null values occurs due to data model design. Might be, subset ratio is not 100% between dim table & measure table. so there is change to get null values in the front end. 

Try to fix this null values in the backend.

Might be, below will help if its comes from same table

NullAsValue DimField;

Set NullValue = 'NA';

[Alarkis]

this is not null value its null dimension because other part of expression is not included in the chosen dimension

measure is like this count(expresion1) + sum (expresion2)

the dimension is related to expression 1.

Not from same table.

[MayilVahanan]

Hi @Alarkis 

Can you provide the sample data \ qvw file.

[Alarkis · Accepted solution]

Solved by creating field 'Value' as DIMNAME from source table before concatenation then Applymap() dimension table to fact table to avoid synthetic keys