Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Probably something similar to Sum(SUM_VALUE) - Above(Sum(SUM_VALUE))
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?
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))
Hi,
your solution was successful.
Thank you.