topic Re: Missing values - Show as zeros in App Development

Missing values - Show as zeros

avl_dlimi — Sat, 16 Nov 2024 19:44:37 GMT

I have a line graph with missing values for august month (purple line). The option to show missing values as zeros does not seem to work as expected when X-axis is set to Continuous.

As a matter of fact the graph is the same no matter which option i choose.

If I turn off Continuous then the Missing values option works as intended.

Re: Missing values - Show as zeros

Kashyap_R — Wed, 06 Nov 2019 09:53:06 GMT

I have taken this as my input table

ZeroReplacement:
LOAD * Inline [
Month,Val1,Val2,Val3
Jan,10,20
Feb,,20,30
Mar,10,60,90
Apr,25,35,190
May,-100,20,
June,100,20,
July,30,60,];

I am getting the values as zero if I am taking as Measure else it is taking it as null

the output is attached

Hope it helps

Thanks

Re: Missing values - Show as zeros

avl_dlimi — Wed, 06 Nov 2019 09:59:23 GMT

The problem is the entire month is missing from the dataset and that continious xaxis do not consider the missing values option

Re: Missing values - Show as zeros

Kashyap_R — Wed, 06 Nov 2019 10:03:18 GMT

Can u attach sample qvf file or data file

I will try and get back to u

Thanks

Re: Missing values - Show as zeros

avl_dlimi — Thu, 07 Nov 2019 07:33:03 GMT

I can't provide a qvf at the moment. But an example of data where March month is missing in the fact table. There is also a date dimension containing all months.

FACT:

ID,Date Key, Val
1,2019-01-01,100
2,2019-02-02,200
3,2019-04-04,40
4,2019-05-05,100
5,2019-06-06,600

Re: Missing values - Show as zeros

Kashyap_R — Fri, 08 Nov 2019 04:45:36 GMT

use If condition in measure

IF(Value <>Null,Value,0)

Thanks

Re: Missing values - Show as zeros

avl_dlimi — Fri, 08 Nov 2019 07:11:30 GMT

My question is rather why the option to set Missing values is not working when using Continuous x axis but it works when using a regular dimension.