topic Re: Chart with accumulative data in QlikView

Chart with accumulative data

vlad_komarov — Fri, 07 Aug 2015 13:54:07 GMT

Hello,

I have a set of data where some amount is represented per month:

04/01/15, 281

05/01/15, 199

06/01/15, 129

07/01/15, 145

08/01/15, 300

I need to create a chart where data point for each month equals sum of all amounts for the last 12 months.

So if the regular line chart looks like this:

I need to create a chart where line looks like this:

There is a flag that represents 12 months period for each data point (Aug/2015, July/2015, etc) - see attached sample.

But I was not able to produce this chart using existing data structure.

Any suggestions how to do that?

Regards,

Vladimir

Gysbert_Wassenaar — Fri, 07 Aug 2015 14:39:45 GMT

See attached qvw

vlad_komarov — Fri, 07 Aug 2015 15:38:56 GMT

Gysbert,

Thanks! I've modified it a little bit, but I like the idea.

Appreciate a quick solution.

Have a nice weekend!

Vladimir

Gysbert_Wassenaar — Fri, 07 Aug 2015 15:45:11 GMT

Glad you liked it. Have a nice weekend too!