Qlik Community

New to Qlik Sense

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

Announcements
Qlik Insider: SaaS capabilities for Data Integration and Analytics, May 25th! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Aggregate actual Month and prior Month

Hi Community,

I have created a bar chart with the value per Month.

bar_qlik.PNG

Now i want the value of the following month to be an aggregation of the prior month'.

E.g.: February = value(February) + value(Janurary)

Thank you in advance!

Greetings,

Florian

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

RangeSum(Above(SUM(Value),0,RowNo()))

View solution in original post

8 Replies
MK_QSL
MVP
MVP

Try this

SUM(Value) + Above(SUM({<Month>}Value))*Avg(1)

ahaahaaha
Partner
Partner

Hi Florian,

Try

RangeSum(Sum(Value), Above(Sum(Value)))

Look attached file.

Regards,

Andrey

arvind_patil
Partner
Partner

Hi Andrey,

It works for me.

Thanks,

Arvind Patil

Not applicable
Author

Hey Andrey,

thank you very much, this works.

Is it possible to also aggregate every month before?

E.g.: December = addition of all month

or

         April = value(Jan)+value(Feb) + value(Mar) + value(Apr)

Not applicable
Author

Thank you this also works.

MK_QSL
MVP
MVP

RangeSum(Above(SUM(Value),0,RowNo()))

Not applicable
Author

Thank you really much for you help! This is exactly what i needed.

ahaahaaha
Partner
Partner

Look attached file. On your data ID in expression should be replaced by the month number, like Num(Month).