Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mandilicious
Creator II
Creator II

count total number of dimension.

Hi All

I am still new in qlikview please assist I need to get total number of Calls Abandoned and Answered queue calls per day  in Statistic table and select Cancellation by in Service_Number table.

I used this expression =Count({<STATISTIC ={'Calls Abandoned'}>}  SERVICE_NUMBER) and Count({<STATISTIC ={'Answered queue calls'}>}  SERVICE_NUMBER) but I am not getting correct total count please correct me if I am wrong. Cause even when I sum I am just getting an error.

You help will be highly  appreciated.

Thanks

1 Solution

Accepted Solutions
Colin-Albert

=Count({<STATISTIC ={'Calls Abandoned'}>}  SERVICE_NUMBER) + Count({<STATISTIC ={'Answered queue calls'}>}  SERVICE_NUMBER)


AND is a Boolean function, + is addition

View solution in original post

6 Replies
Colin-Albert

Try

Count({<STATISTIC ={'Calls Abandoned','Answered queue calls'}>}  SERVICE_NUMBER)

trdandamudi
Master II
Master II

Can you please share a sample....

Colin-Albert

=Count({<STATISTIC ={'Calls Abandoned'}>}  SERVICE_NUMBER) + Count({<STATISTIC ={'Answered queue calls'}>}  SERVICE_NUMBER)


AND is a Boolean function, + is addition

sunny_talwar

Sorry, did not see your response

mandilicious
Creator II
Creator II
Author

Thank you very very much Colin.

mandilicious
Creator II
Creator II
Author

I also trying to  use  gauge graph to calculating Abandoned by using using this given formula  =Sum('Calls Abandoned')/Sum('Answered queue calls') in my expression  but I am getting an error by using Sum.