graph with accumulated values

[alejandrodiaz]

I am having a problem with the cumulative values of my graphs, my example is:
I am accumulating a count of values, by month and by person, and when for example a person has not generated a record that month, the chart is not able to accumulate the values. Do you know how I can correct this problem?

Example with data

name	month	value
alex	Jan	20
alex	feb	21
alex	apr	22

In this example with this data when it reaches the month of March it is not able to paint the line and show the accumulated value that would be the previous month.

Has it happened to anyone else? best regards

Qlik Sense Business 

[vikasmahajan]

Hi,

You need to implement master calendar in your data model , using calendar generation we can generate all time periods  & once it is generated suppose march month in your case . 

Refer following link to implement the master calendar :

https://community.qlik.com/t5/Member-Articles/Create-Simple-Master-Calendar-FY-April/ta-p/2054943

after implementing calendar you will able to 0 zero in the month of march.

Thanks

Vikas