1 Reply Latest reply: Jun 15, 2018 9:14 AM by Sunny Talwar RSS

    Accumulation is not coming correctly with 2 dimensions

    subash chandra

      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