sum by month if month before is empty

[madmax88]

Hi all,

I have following table:

Customer	Month	Value
A	31.12.2017	500
A	31.01.2018	505
A	28.02.2018	510
A	31.03.2018	520
B	28.02.2018	200
B	31.03.2018	205
C	31.12.2017	300
C	31.01.2018	300
C	28.02.2018	300

I need a Pivot Table by month were it should Show a value if the month before or after is missing (or 0). But I dont a growth number  if there is a value at the month before and after. The result should be (Start Date is the 31.01.2018 - The date 31.12.2017 is only displayed to see if there is a value in the month before or not):

Do you have any idea?

	Month
Customer	31.01.2018	28.02.2018	31.03.2018
A	0	0	0
B	0	200	0
C	0	0	-300

[sunny_talwar]

I think you might need to Generating Missing Data In QlikView‌ in order to accomplish this