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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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) )