topic Re: Multi-Dimensional Pie Chart in QlikView

Multi-Dimensional Pie Chart

Tue, 24 Dec 2013 12:12:37 GMT

Hi,

is it possbile to create Multi-Dimensional Pie Chart in qlikview?

Thanks

Re: Multi-Dimensional Pie Chart

Tue, 24 Dec 2013 12:18:48 GMT

yes you can.

Re: Multi-Dimensional Pie Chart

Tue, 24 Dec 2013 12:20:47 GMT

Any sample qvd file showing the same would be appreciated.

Re: Multi-Dimensional Pie Chart

Gysbert_Wassenaar — Tue, 24 Dec 2013 12:22:53 GMT

Yes and you shouldn't. Multidimensional pies are incredibly hard to understand. If you get a kick out of confusing your users then use them. Otherwise use a bar chart instead.

Re: Multi-Dimensional Pie Chart

Tue, 24 Dec 2013 12:26:38 GMT

Thanks...i just want to show the qlikview capability to my client. this looks cool in excel.

can anybody share any samples since this looks complex to me.

Re: Re: Multi-Dimensional Pie Chart

Gysbert_Wassenaar — Tue, 24 Dec 2013 12:31:36 GMT

See attached qvw.

Re: Multi-Dimensional Pie Chart

Tue, 24 Dec 2013 13:09:04 GMT

thanks for your promopt reply. Now, i have couple of queries:

1- I noticed that i can have onnly 1 level of drill-down. Month and product. I am unable to add any other dimension. Does qlikview allows only 1 layer of drill down in pie chart?

2- I agree with you. This looks too clustered an very colorful. However, my dataset is small. I have a specific requirement here.

- To make it more simple and clean, lets remove 'month' from dimension and instaed add 'year' (Year should be the second dimension)

- Now my requirement is that, all the 3 visible years should take the color of the product to which they belong. For eg: the color of cherry segment is green. all the 3 yaers below cherry should be green and the same logic should apply to other products and years.

Your help on thsi would be appreciated.

Re: Multi-Dimensional Pie Chart

Gysbert_Wassenaar — Tue, 24 Dec 2013 13:18:53 GMT

What you're doing is not really drilling down, but filtering by selecting a value in a dimension. If you want to drill down create drilldown groups and use those as dimensions.

If you want every slice to have the color of the product add a color expression to the expression by clicking on the + in front of the expression, clicking Background Color and adding this as color expression: color(FieldIndex('Product',Product)).

Re: Multi-Dimensional Pie Chart

Tue, 24 Dec 2013 13:31:45 GMT

thanks a ton. The color stuff worked.

The color stuff will look good if i can display the quarters on the pie. In the Year dropwdon there are 4 quarters. Is there any way to have TEXT "Q1" in the middle of the Q1 pie AREA and Q2 in the middle of Q2 pie area and so on so that the user can distinguish the labels for the second level as currently legends show some other color and the 2nd level shows the color of the layer above which dont match with the legends.

Hope you getting my point.

Re: Multi-Dimensional Pie Chart

Gysbert_Wassenaar — Tue, 24 Dec 2013 13:50:42 GMT

No, you can't show values in pie slices (unless you do it manually with text-in-chart objects). This is another reason why you should use a bar chart.

Re: Multi-Dimensional Pie Chart

Tue, 24 Dec 2013 14:22:00 GMT

alright. so my last question before closing this tread. Can we add 3 dimensions? i used the wrong terminilogy last time (drill-down),...i just want to show 3 dimensions....for eg : 1st dimention should be year followed by quarter and then month.

thanks in advance

Re: Multi-Dimensional Pie Chart

Gysbert_Wassenaar — Tue, 24 Dec 2013 14:23:27 GMT

Create a drilldown group with year, quarter and month as fields and then use that drilldown group as dimension. You can create groups using the Groups button on the Dimensions tab.

Re: Multi-Dimensional Pie Chart

Tue, 24 Dec 2013 14:44:33 GMT

Re: Multi-Dimensional Pie Chart

Tue, 24 Dec 2013 14:50:09 GMT

somehow i managed to show the values for quarters ......just the values for year is incorrect. is there any way to correct that?

also, a drill down wont do since i want to show all 3 dimensions at once ...please refer to the pie chart at the left. i want a pie similar to that (3 layers at once)

thanks

Re: Multi-Dimensional Pie Chart

Wed, 25 Dec 2013 04:35:35 GMT

Merry Christmas to all...

Guys please help here....is showing 3 dimensions (not by grouping) as shown in the above screenshot (right pie chart) possible?

Also, is there any way to rectify the data values for the Year (refer to the above screenshot)?

Re: Multi-Dimensional Pie Chart

Thu, 26 Dec 2013 07:46:23 GMT

any help?.....: (

Re: Multi-Dimensional Pie Chart

Gysbert_Wassenaar — Thu, 26 Dec 2013 18:28:56 GMT

Put two pie charts on top of each other. Hide the caption etc of the top pie and set the transparency on the Colors tab to 100%.

Re: Multi-Dimensional Pie Chart

Fri, 27 Dec 2013 13:00:11 GMT

That Worked......Thanks a ton...any other such manipulative method 2 add 3rd dimension?....

Re: Multi-Dimensional Pie Chart

Wed, 26 Mar 2014 10:06:06 GMT

Hi guys,

I couldn't set the background color using the expression, can you provide with a sample file?

Thank you very much guys

Re: Re: Multi-Dimensional Pie Chart

Wed, 26 Mar 2014 10:12:01 GMT

PFA the multi-dimensional pie chart.