Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Our Call Centre use an in-built designed piece of software that allows them to record the type of call they've received, i.e. Resolved, Callback or Transfer. This is marked in the database as either True (1) or False (0). QlikView is extracting this data and I've been asked to create a pie chart to show the total number of calls received but then split (by %) by these three areas. I can't quite get my head around how to do this as there are three different data sets. Thanks in advance.
I guess have no dimension and use three expressions:
Exp1:
=Count({<Resolved = {'True'}>}[No of Calls])
Exp2:
=Count({<Callback= {'True'}>}[No of Calls])
Exp3:
=Count({<Transfer= {'True'}>}[No of Calls])
My assumption is that only one of the three fields will have a True because its an OR scenario.
Hi Melanie
what you are saying is that Resolved, Callback or Transfer are 3 different files? Why not concatenate them?
please share some sample data
It will be easy for us to help
I guess have no dimension and use three expressions:
Exp1:
=Count({<Resolved = {'True'}>}[No of Calls])
Exp2:
=Count({<Callback= {'True'}>}[No of Calls])
Exp3:
=Count({<Transfer= {'True'}>}[No of Calls])
My assumption is that only one of the three fields will have a True because its an OR scenario.
HI Melanie,
can you supply any example data, or even an example QVW?
Andy
If your record set looks like
CallID, Resolved, Callback, Transfer
Try a pie chart (if the really want a pie chart) without dimension and three expressions:
=count({<Resolved = {1}>} distinct CallID)
=count({<Callback = {1}>} distinct CallID)
=count({<Transfer = {1}>} distinct CallID)
Checking the relative option should get the percentage in.
Many thanks for the prompt replies peeps.
Sunindia, your script has done the trick You were right, only one of these fields can be true. I'm still trying to understand what it is actually saying but it works so am really pleased.
I've now got the actual number of calls included in the legend but would like it if I could have the % displayed around the chart. Using the 'Relative' or 'Values on Data Points' doesn't seem to work in this scenario.
Update: Forgot to add a closing single quote after '#.00% (updated it now)
Try changing your expressions to these and see if that works:
Exp1:
=Num(Count({<Resolved = {'True'}>}[No of Calls])/Count([No of Calls]), '#.00%')
Exp2:
=Num(Count({<Callback= {'True'}>}[No of Calls])/Count([No of Calls]), '#.00%')
Exp3:
=Num(Count({<Transfer= {'True'}>}[No of Calls])/Count([No of Calls]), '#.00%')
Hi sunindia,
Apologies for the delay in getting back to you. Does the above need to be input as additional expressions similar to the ones I already have or does the existing definition need amending to the above for these? If I update them to the revised definitions, the legend numbers change to percentages (I'd like them to stay as numbers) and only one percentage is displayed on my pie chart.
Thanks.
Hi Melanie -
What exactly is your requirement? In the legend do you want to see numbers of percentages? If you can explain the requirement, I will be able to give you a better response.
Best,
Sunny