topic how to create special pie chart? in QlikView

how to create special pie chart?

Thu, 02 Sep 2010 13:56:29 GMT

I have following data:
Category PartA PartB PartC
A 5 3 2
A 10 4 1
A 3 6 11
A 2 4 8
B 3 0 2
B 5 1 4
C 6 4 2
C 2 0 1

if I select in QlikView sheet (in object ListBox LB01) value "A"
I want create pie chart which display ratio of PartA, PartB and PartC on summary data of "A".
In this case it will be pie chart consists of three parts - first slice will have value of 20 (result of PartA values: 5+10+3+2)
second will have value of 17 (3+4+6+4) and third slice will be value of 22 (2+1+11+8).
Whole of pie will be value of 59 (result of all PartA values, PartB values and PartC values).

Or if I select value "B", pie chart will be three parts. First=8 (3+5), second=1 (0+1), third=6 (2+4)

How can I create that pie chart?

thanks

how to create special pie chart?

Thu, 02 Sep 2010 14:54:02 GMT

Which version do you use?

If 9 or higher, you can use a Trellis Option.....and show 3 graphs....each category.....

....or with you prefer you can put a IF on your expression...

look on the help about GetSelectField.....is helpfull

how to create special pie chart?

mike_garcia — Thu, 02 Sep 2010 15:00:29 GMT

If I understood correctly, you can solve it by creating a Pie Chart with no dimensions and three expressions. Sum(PartA), Sum(PartB) and Sum(PartC).

Hope this helps.

Mike.

how to create special pie chart?

jedgson — Thu, 02 Sep 2010 15:07:29 GMT

You can create a Pie chart with no dimensions, and then create 3 expressions:

1 - Sum(PartA)

2 - Sum(PartB)

3 - Sum(PartC)

This will be calculated across all categories - You can then select the category via a selection box

how to create special pie chart?

jedgson — Thu, 02 Sep 2010 15:08:40 GMT

I was a little slow in replying!! 🙂

how to create special pie chart?

johnw — Thu, 02 Sep 2010 23:36:20 GMT

Or you could change your data model. PartA, PartB and PartC sound more like values than fields to me, though obviously you know your data better than I do, and this is almost certainly a hypothetical example:

CROSSTABLE (Part,Value)
LOAD * INLINE [
Category, PartA, PartB, PartC
A, 5, 3, 2
A, 10, 4, 1
A, 3, 6, 11
A, 2, 4, 8
B, 3, 0, 2
B, 5, 1, 4
C, 6, 4, 2
C, 2, 0, 1
];

dimension = Part
expression = sum(Value)

how to create special pie chart?

Fri, 03 Sep 2010 08:06:50 GMT

thanks to all,

it works (pie chart without dimension, with 3 expressions), but little problem remains:

buble popup on each pie chart slice displays the same text - first expression label (!) although numbers are right (depends on pointed slice)

how to create special pie chart?

Thu, 23 Sep 2010 09:06:38 GMT

Hi Jura,

I have the same problem in my pie chart. The pop up shows only the label of the first expression to all slices.

Any idea?

Thanks

how to create special pie chart?

Thu, 23 Sep 2010 15:39:15 GMT

Nadsky,

Did you checked a Text as pop-up on each expression??

how to create special pie chart?

Fri, 24 Sep 2010 05:07:02 GMT

HI Erico,

I checked the "Text as Pop Up" in each expression but still the label of first expression displays on all slices. I tried also not checking "Text as Pop Up".

By the way, my Pie Chart has no dimension.

Thanks!

how to create special pie chart?

Mon, 27 Sep 2010 14:21:22 GMT

Maybe is same bug.....try to build again!!!!

Never happen that with me!!!!!

how to create special pie chart?

montubhardwaj — Wed, 17 Nov 2010 13:57:40 GMT

Hi Ronald,

Perhaps it is late now and you would have resolved it. I just wanted to update this post

To have the other expressions as pop-up, we can do little "work around" here.

For example, suppose you have 3 expressions say (sales,profit and margin). By default, QV8 will pop-up only for 1st expression.In order to make other also as pop-up, do the following"

hardcode the expression with the name as you want to see in the pop-up. For example, if you want to see pop-up as "Profit= <value>", then hardcode it as

='Profit=' & Sum(Profit)

follow the similar technique for other expressions also.

Note: Make sure you check "Text as Po-Up".

Hope that was helpful.

Re: how to create special pie chart?

Anonymous — Mon, 09 Jul 2018 16:31:30 GMT

That didn't help to me. Where did you change that ='Profit=' & Sum(Profit) ? I changed that in Definition and the Label of the expressions without sucess. Do you have an exemple?