Discussion Board for collaboration related to QlikView App Development.
I want to add current month data with previous data in pivot table.
Please see the attached screenshot.
For month, I have taken monthnumber i.e. 1,2,3,etc.
I want output as , in monthnumber 2 , monthnumber 1 + monthnumber 2 values addition should come.
For example: For Ahmedabad, in monthnumber 2 value should come as 250 (126+124).
Experssion used : sum(NOS)
Kindly help me to solve this issue.
Do you want to add only one previous or every previous months?
Month2 =month1 +month2
Month3 =month1 +month2 +month3
Month4= month1 +month2 +month3+month4
i want to add only one previous month.
Month3 =month2 +month3
Try then expression: sum(NOS) + if(before(sum(NOS))>0,before(sum(NOS)),0)