Add Weekend or Non-Working Days as Report Date into Fact Table with measurement = 0

[olks]

Hi Qlik Experts! 

Given that I have a data as shown as screenshot below, notice that the Report_Date does not have 15/6/2023, 16/6/2023 in it as it was a non-working day so we does not have that particular data. 

I have a master calendar that populate all date include those non-working days or weekend date. 

Now I would like to show the non-working days or weekend date that do not have data in my Pivot Table chart as 0 for the measurement. 

How do I force to add the non-working days or weekend date to the table with the dimension follows back previous date but measurement as 0.

Example (before) : 

Report_Date	DEPT1	ACOF1	OFFICER	NAME1	CPA_CMF	measurement1
13/6/2023	J3	123	1	ABC	2	100
14/6/2023	J3	123	1	ABC	2	101
17/6/2023	J3	123	1	ABC	2	10
18/6/2023	J3	123	1	ABC	2	90

Example (after):

Report_Date	DEPT1	ACOF1	OFFICER	NAME1	CPA_CMF	measurement1
13/6/2023	J3	123	1	ABC	2	100
14/6/2023	J3	123	1	ABC	2	101
15/6/2023	J3	123	1	ABC	2	0
16/6/2023	J3	123	1	ABC	2	0
17/6/2023	J3	123	1	ABC	2	10
18/6/2023	J3	123	1	ABC	2	90

Appreciate your help!

Thanks,

olks

[jonashertz]

Could it be that you just need to check "Include Zero Values"?