topic Re: Another chart question... in QlikView

Another chart question...

Fri, 12 Jun 2015 11:00:27 GMT

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.

Re: Another chart question...

giakoum — Fri, 12 Jun 2015 11:11:17 GMT

Hi Melanie

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

Re: Another chart question...

Anonymous — Fri, 12 Jun 2015 11:12:51 GMT

please share some sample data

It will be easy for us to help

Re: Another chart question...

sunny_talwar — Fri, 12 Jun 2015 11:12:53 GMT

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.

Re: Another chart question...

awhitfield — Fri, 12 Jun 2015 11:16:41 GMT

HI Melanie,

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

Andy

Re: Another chart question...

swuehl — Fri, 12 Jun 2015 11:18:25 GMT

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.

Re: Another chart question...

Fri, 12 Jun 2015 12:12:25 GMT

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.

Re: Another chart question...

sunny_talwar — Fri, 12 Jun 2015 12:17:23 GMT

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

Re: Another chart question...

Tue, 16 Jun 2015 11:55:04 GMT

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.

Re: Another chart question...

sunny_talwar — Tue, 16 Jun 2015 12:07:47 GMT

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

Re: Another chart question...

Tue, 16 Jun 2015 12:40:20 GMT

Apologies for not being very clear.

I'd like numbers in the legend and percentages displayed around the chart if that's possible.

Thanks.

Re: Another chart question...

sunny_talwar — Tue, 16 Jun 2015 15:23:19 GMT

Let me look into it and get back to you with a solution.

Best,

Sunny

Re: Another chart question...

sunny_talwar — Tue, 16 Jun 2015 15:40:19 GMT

I just gave it a try, Both the legend and Value on chart seems to follow the same display format. If I try to change legend to number, the value on chart becomes number to. The only work around this is to add text to the chart and place them where ever you want to (potential problem is that the display won't be dynamic enough to move when the pie moves.

Best,

Sunny

Re: Another chart question...

Wed, 17 Jun 2015 07:03:29 GMT

Hi Sunny,

Many thanks for looking into this for me... I really do appreciate it

Mel.

Re: Another chart question...

sunny_talwar — Wed, 17 Jun 2015 10:09:53 GMT

Not a problem, I just wish I could have been of more help.

Sunny