Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
March 11, 2PM EST: Do More with Qlik - Getting Started wtih Qlik Sense SaaS - Redux. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
madmax88
Creator II
Creator II

sum by month if month before is empty

Hi all,

I have following table:

   

CustomerMonthValue
A31.12.2017500
A31.01.2018505
A28.02.2018510
A31.03.2018520
B28.02.2018200
B31.03.2018205
C31.12.2017300
C31.01.2018300
C28.02.2018300

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
Customer31.01.201828.02.201831.03.2018
A000
B02000
C00

-300

1 Reply
sunny_talwar

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