Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Vijen_M
Contributor III
Contributor III

Query for a dashboard i have  this table where ,i want to calculated number of answered and number of unanswered call, and then make kpi seprately

Call centre.png

Labels (3)
1 Reply
brunobertels
Master
Master

hi may be this 

 

answered 

count({<Answered (Y/N)={'Y'}>} Answered (Y/N) ) 

non answered 

count({<Answered (Y/N)={'N'}>} Answered (Y/N) ) 

 

total received : 

count(Answered (Y/N) ) or count( Total Answered (Y/N) )