Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Is there a way to have a table calculate a total with above restriction?
Fixed by moving the IF statement to the Set expression