0 Replies Latest reply: Aug 1, 2016 8:37 PM by Jeferson Evangelista RSS

    Accumulated values by week

    Jeferson Evangelista

      Hi,

      I am new to Qlik Sense Desktop and I have an issue with table and graphic with accumulated values and data log.

      In my scenario, I have gap list and this generate log table with timestamp field and the advance in hours, so every time something change in that table, the record is save in that table.

      The data was loaded with no problems in Qlik Sense Desktop, and in the load, I did a transformation in timestamp with <week> instruction.  No problem up to here.

      The issue is that sometime during the whole week I have no advance in hours. Here, a subset of records.

       

       

      weekHows_ModifiedGAP IDHSum(Effort_H)
      242016-06-07 11:35:520060,00
      242016-06-07 17:47:5100614,67
      242016-06-08 09:55:0400516,00
      242016-06-08 12:09:3100614,67
      252016-06-15 09:44:0700616,00
      252016-06-15 12:01:1200516,00
      252016-06-15 14:27:2300616,00
      252016-06-15 14:28:1200516,00
      252016-06-15 14:31:4100616,00
      262016-06-20 11:58:4600516,00
      262016-06-20 11:59:3500516,00
      262016-06-21 15:51:2500526,67
      262016-06-21 15:52:0700526,67
      262016-06-21 15:52:5900526,67
      262016-06-23 11:58:1100526,67
      262016-06-23 15:28:4800532,00
      272016-06-30 14:56:2200532,00
      272016-06-30 14:56:3200616,00
      292016-07-15 15:28:1700532,00
      302016-07-20 17:45:2500616,00

       

      Therefore, based on these data considering GAP ID 005 and GAP ID 006 as example, I should have an accumulated total equal to 48 hours.  31 hours in week 24, 32 hours in week 25 and 48 hours in week 26 and next ones.Only the last record from each GAP and last record from each Week should accumulate values.

      2016-08-01_211825.png

      I found some threads with almost same case, using something like Sum({$<weekH = {"$(=Max(weekH))"}>} Effort_H) but I have no success.

      Attached is the “.qvf” APP. I appreciate your help.

      Thanks