Adding Dimension for Pie Chart

jarebpat — Thu, 06 Dec 2012 19:41:17 GMT

In the attached example we are calculating the movement of products in the past rolling year. If there is at least one sale per month it counts as "1". A product becomes popular when it reaches the "12" level, similarly a product is not popular when value is in the low end (ex. 0-3).

I need to show this as a Pie Chart...0 to 12 (clock format style). The twelve being colour coded green as a popular product and the 0-3 as red as not popular.

Upon clicking on any section 0-12 the product should display on a seperate table chart. Each slice becomes a selection.

I am not able to get Qlikview to produce this. I believe the calculation would need to be in the script section and be used as a dimension. Or is there a better way? Feedback is welcome.

Re: Adding Dimension for Pie Chart

Thu, 06 Dec 2012 22:16:21 GMT

It sounds like it would be easier to do this using a Gauge chart instead of a pie graph. The one drawback is that it won't let you select a number on the chart and automatically filter your data like you want. To get around this, I hid some text objects with 'Select in Field' actions. See if the attached document is similar to what you are looking for at all.

topic Re: Adding Dimension for Pie Chart in QlikView

Adding Dimension for Pie Chart

Re: Adding Dimension for Pie Chart