topic How to display the field with 0 values in a table chart in App Development

How to display the field with 0 values in a table chart

abc_18 — Fri, 13 Dec 2019 16:56:25 GMT

Hello,

I have a field called product, under that total 4 values are present in master table, i have to show the count in a table chart.

Ex:-

Product

Now the child table, which i am using having only two values A and B present, but in table chart it should display all 4 products.

Like below:

A 10

B 12

C 0

D 0

How can I achieve this, please suggest.

Regards

Prashant_Naik — Fri, 13 Dec 2019 17:24:01 GMT

Hi,

you can use Applymap() function

Mappingtbl:

mapping load distinct

product, value

from table;

parenttable:

load,

product,

Applymap('Mappingtbl',product,0) as Value

from parent_table;

Regards,

Prashant

abc_18 — Fri, 13 Dec 2019 18:34:34 GMT

Hi Prashant,

I have to achieve this directly in table chart, can't use applymap functionality.

And value is nothing but a mesaure expression created in chart.

Any other way around?

Thanks