Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

Re: Aggregate actual Month and prior Month

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

8 Replies

Re: Aggregate actual Month and prior Month

Try this

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

ahaahaaha
Honored Contributor

Re: Aggregate actual Month and prior Month

Hi Florian,

Try

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

Look attached file.

Regards,

Andrey

arvind_patil
Valued Contributor II

Re: Aggregate actual Month and prior Month

Hi Andrey,

It works for me.

Thanks,

Arvind Patil

Not applicable

Re: Aggregate actual Month and prior Month

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

Re: Aggregate actual Month and prior Month

Thank you this also works.

Re: Aggregate actual Month and prior Month

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

Not applicable

Re: Aggregate actual Month and prior Month

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

ahaahaaha
Honored Contributor

Re: Aggregate actual Month and prior Month

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