Calculation of the difference of the month with the value of the previous month

[LaettaMan]

Hi everybody,

I am in the process of creating a report in QlikView.

I have the following monthly chart with four columns. 

Month          SUM_QUANTITY                     SUM_VALUE                     +/- PREMONTH
January          31.064.128                                 4.698.123
February        28.421.257                                 4.042.789
March              30.687.398                                 4.374.989
April                 30.189.756                                 4.214.028

I would now like to enter the deviation from the previous month in the column "+/- PREMONTH" for the column VALUE.
So for the month April the deviation to the month March should be entered, for the month March the deviation to the month February should be entered and so on.

For the month of april, the value should be in the field -160.961 (difference to march).

For the month of march, the value should be in the field 332.200 (difference to february). 

What does the solution to my question look like?

Thank you.

 Rainer

[Or]

Probably something similar to Sum(SUM_VALUE) - Above(Sum(SUM_VALUE))

[LaettaMan]

Hi Or,

thank you for your quick answer. 

Sorry, but your solution doesn't give me any values back in the column "+/- PREMONTH"

The dimension is VALUE and not SUM_VALUE (sum_value is the column name in the chart). Sorry.

What is here the problem? 

[Or]

Your issue is likely with the added dimension - in your original example there was only one dimension, but here you have two. You may need to add a TOTAL qualifier.

Sum(SUM_VALUE) - Above(total Sum(SUM_VALUE))

[LaettaMan]

Hi,

your solution was successful.

Thank you.