Compare Sum of Month with Sum of previous Month

[#1]

Hi all,

I would like to calculate the sum of a Month and compare it with the sum of the previous month to find the difference between those two.

E.g.    sum(Anzahl_Autos) //in February

          sum(Anzahl_Autos) //in January

// And the find the difference

And so on over the whole year. So that I can build a chart to display the 'Growth' of several Periods

I tried a lot, but couldn't find a solution.

In the attached file you can find some test data.

It would be so nice if somebody could help me with that.

Kind regards

Philipp

[marcus_sommer]

Have a look on the last links in this posting: How to use - Master-Calendar and Date-Values

- Marcus

[Anonymous]

go through following threads:

Month-on-Month comparison

How to calculate month-on-month comparison?

Help comparing months data in pivot table?

Month by Month Comparison

Year-over-Year Comparisons

QlikView App: Set Analysis - Prior Period Comparison

Hope this will help

[jonathandienst · Accepted solution]

In the table showing quantity by month, add the expressions:

=Column(1) - Alt(Above(Column(1)), 0)                                   // for growth

=Alt((Column(1) - Above(Column(1))) / Above(Column(1)), 1)   // for % growth

[#5]

hi, thanks for the help!!

Is it possible, or is there a way to use the above() function also if I have 2 dimensions?!

[Anonymous]

Just add your required dimension, it should work.