Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

subashchandra_m
New Contributor

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

Year-Month-Week

Carry from Last week(s)Planned TaskClosed In TimeClosed Old

Moved to Next week

(Pending Tasks)

2018-jun-W2408404
2018-jun-W2545540
2018-jun-W2606204
2018-jul-W2749139

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.

Output Coming like this: Not Working

Year-Month-Week

User

Carry from Last week(s)Planned TaskClosed In TimeClosed Old

Moved to Next week

(Pending Tasks)

2018-jun-W24Harry03102
     2018-jun-W24John25304
2018-jun-W25Harry44224
     2018-jun-W25John41320
2018-jun-W26Harry03201
2018-jun-W26John13102
2018-jul-W27Harry25133
2018-jul-W27John34106

But i Want like this:Expecting this

Year-Month-Week

User

Carry from Last week(s)Planned TaskClosed In TimeClosed Old

Moved to Next week

(Pending Tasks)

2018-jun-W24Harry03102
     2018-jun-W24John05302
2018-jun-W25Harry24222
     2018-jun-W25John21120
2018-jun-W26Harry23203
2018-jun-W26John03102
2018-jul-W27Harry35134
2018-jul-W27John24105

Thanks and Regards

Subash

1 Reply

Re: Accumulation is not coming correctly with 2 dimensions

May be wrap around your RangeSum() expression with Aggr()

Aggr(...YourExpression..., User, [Year-Month-Week])

Community Browser