Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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 - Master
Partner - Master

Hi Florian,

Try

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

Look attached file.

Regards,

Andrey

arvind_patil
Partner - Specialist III
Partner - Specialist III

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 - Master
Partner - Master

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