count total number of dimension.

[mandilicious]

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

[Colin-Albert]

Try

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

[trdandamudi]

Can you please share a sample....

[Colin-Albert · Accepted solution]

=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]

Thank you very very much Colin.

[mandilicious]

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.