Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
Solved by creating field 'Value' as DIMNAME from source table before concatenation then Applymap() dimension table to fact table to avoid synthetic keys
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';
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.
Hi @Alarkis
Can you provide the sample data \ qvw file.
Solved by creating field 'Value' as DIMNAME from source table before concatenation then Applymap() dimension table to fact table to avoid synthetic keys