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: 
Not applicable

Another chart question...

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.

1 Solution

Accepted Solutions
sunny_talwar

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.

View solution in original post

14 Replies
giakoum
Partner - Master II
Partner - Master II

Hi Melanie

what you are saying is that Resolved, Callback or Transfer are 3 different files? Why not concatenate them?

Anonymous
Not applicable
Author

please share some sample data

It will be easy for us to help

sunny_talwar

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.

awhitfield
Partner - Champion
Partner - Champion

HI Melanie,

can you supply any example data, or even an example QVW?

Andy

swuehl
MVP
MVP

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.

Not applicable
Author

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.

sunny_talwar

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%')

Not applicable
Author

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.

sunny_talwar

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