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:

       

      if(

      24*Sum({<[CICStatus.StatusKey]={'mail'}>}[CICStatus.StateDuration])=0,0,

      Sum([NonVoice.verwerkt]))

       

      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?