How to Replace Null Values with Zero Values when Multiple Dimensions are there in Bar Chart

[SatyaPaleti]

Hi Folks,

Can some one please help me to replace Null values with Zero's. We have a Product A Product B & Product C and we were showing Monthly Production Growth.

We are using Dimensions Month & Product and Measure is Count(Emp ID)  

We have Product A, Product B & Product C count in October 2017 but we dont have Product B & Product C in Nov-2017. In this Case we have to show Zero for values Missing as you can refer below screenshot

Please find attached document for Mock Data. Can some one please help to resolve this Issue. We are loading data from single table only which is in Mock Data . So please let me know if i need to make a change in the script

Thanks and Regards,

Satya

[MayilVahanan]

HI @SatyaPaleti 

Try like below

T:
LOAD St_Month,
site,
Count
FROM
[D:\Qlik\personnal\Test_Data.xlsx]
(ooxml, embedded labels, table is Sheet1);

Temp:
Load Distinct
St_Month Resident T;

Join
LOAD Distinct site Resident T;

Join(T)
LOAD * Resident Temp;

DROP Table Temp;

[SatyaPaleti]

Hi Vahana,

Thank you so much for your responce on this. Still I cant able to see any zero values instead of null