topic Re: Rename Null value in chart in App Development

Rename Null value in chart

Alarkis — Sat, 16 Nov 2024 01:04:20 GMT

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)

Re: Rename Null value in chart

MayilVahanan — Sun, 22 Nov 2020 09:31:13 GMT

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';

Re: Rename Null value in chart

Alarkis — Sun, 22 Nov 2020 10:17:37 GMT

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.

Re: Rename Null value in chart

MayilVahanan — Mon, 23 Nov 2020 02:03:44 GMT

Hi @Alarkis

Can you provide the sample data \ qvw file.

Re: Rename Null value in chart

Alarkis — Mon, 23 Nov 2020 11:01:52 GMT

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