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

olks — Fri, 15 Nov 2024 21:40:14 GMT

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

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

jonashertz — Mon, 19 Jun 2023 09:31:11 GMT

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

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

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

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