Accumulation is not coming correctly with 2 dimensions
Hi Qlik Guys,
I'm new to the qlik.
From last few months i'm facing the below problem.For single dimension i have achieved the straight table as i want but when i'm adding second dimension the calculated measures not working.
For Single dimension Accumulation:Working
Carry from Last week(s)
Closed In Time
Moved to Next week
here Carry from last week(s) and Moved to Next Week are calculated fields
Moved to Next week = (carry From Last Week(s) +Planned Task) - (Closed In Time+Closed Old)
Carry From Last week(s)= above value of ' Moved to next week'........Range(sum(above())) function i have used here
Still here i getting exact value what i want but when i want to add the task users dimension field then the values are not coming correctly because of above function is used in the table .Please anyone suggest me here.