Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

mandilicious
New Contributor III

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

Re: count total number of dimension.

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


AND is a Boolean function, + is addition

6 Replies

Re: count total number of dimension.

Try

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

trdandamudi
Honored Contributor

Re: count total number of dimension.

Can you please share a sample....

Re: count total number of dimension.

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


AND is a Boolean function, + is addition

Re: count total number of dimension.

Sorry, did not see your response

mandilicious
New Contributor III

Re: count total number of dimension.

Thank you very very much Colin.

mandilicious
New Contributor III

Re: count total number of dimension.

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.

 

Community Browser