12 Replies Latest reply: Jun 22, 2011 4:20 AM by Arun Raj RSS

    Problem with QV10 sum formula (works in QV8 and QV9)

    Klaus Feldam
      Greetings fellow QlikCommunity members.
      We have a set of call recording reports we are running based on data from our telephone system.

       

      Following an otherwise successful QV10 SR2 upgrade this weekend, the result of the following formula has changed in QV10:
      (SUM ([Answered Active Time])/Sum ([Number of Answered Calls])/24/60/60)

      With this formula, we are simply calculating the average talk time for an agent based on the 'Answered Active Time' and the 'Number of Answered Calls'. The calculation works as intended in QV8 and QV9, but doubles the Average Talk Time in QV10. See below extract for the difference in the calculation. The formula for the ATT columns are the same.

       

      See attached QVW. User-ID: ADMIN / Password: ADMIN.

       

      Any assistance would be highly appreciated.
      Answ   Active TimeAnsw CallsATT (post QV10) Incorrect calculationATT (QV8 / QV9) Correct calculation
      -359607:39-
      82102:4401:22
      386112:5206:26
      98103:1601:38
      985132:5016:25
      970132:2016:10
      -118:12-
      -105:42-
      151105:0202:31
      125104:1002:05
      -105:50-
      77102:3401:17
      116103:5201:56
      -109:20-
      73201:1300:36
      196203:1601:38
      -204:06-
      -211:41-
      -107:32-
      163105:2602:43
      -106:38-
      356111:5205:56
      417113:5406:57
      113301:1500:38
      115301:1700:38
      270303:0001:30
      85400:4200:21
      91400:4600:23
      438403:3901:49
      832406:5603:28
      781308:4104:20
      204302:1601:08
      474305:1602:38
      384112:4806:24

      Best regards,
      Klaus Feldam