1 Reply Latest reply: Sep 28, 2018 2:43 AM by Job van Atten RSS

    Total in table doesn't match individual values

    Job van Atten

      I have a straight table in Qlik Sense that calculates the number of Mails answered and the corresponding AHT. Sometimes employees don't use the right status for this work so I disregard these withe the following expression:






      For individual records this works well, but the table total still calculates all Sum([NonVoice.verwerkt]) since Sum({<[CICStatus.StatusKey]={'mail'}>}[CICStatus.StateDuration]) for the total records is not equal to zero.

      Total #Mails should be 64 (18+9+20+17), AHT should be 3600*5,99/64.

      MailAHT QS.JPG

      Is there a way to have a table calculate a total with above restriction?