# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
cancel
Showing results for
Did you mean:
Not applicable

## Compare Sum of Month with Sum of previous Month

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

1 Solution

Accepted Solutions
Partner - Champion III

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
5 Replies
MVP & Luminary

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

- Marcus

Champion
Partner - Champion III

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable
Author

hi, thanks for the help!!

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

Champion