Adding Dimension for Pie Chart

[jarebpat]

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.

[#2]

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.