topic Re: Compare Sum of Month with Sum of previous Month in QlikView

Compare Sum of Month with Sum of previous Month

Thu, 12 Nov 2015 08:31:25 GMT

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 — Thu, 12 Nov 2015 08:36:29 GMT

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

- Marcus

Anonymous — Thu, 12 Nov 2015 08:39:57 GMT

go through following threads:

Hope this will help

jonathandienst — Thu, 12 Nov 2015 08:48:46 GMT

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

Thu, 12 Nov 2015 09:24:08 GMT

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 — Thu, 12 Nov 2015 09:32:28 GMT

Just add your required dimension, it should work.