Pie Chart

[suryaa30]

Below is my load script.

Fruits:

LOAD * INLINE [

    Product, Qty, Sales, F4

    Apple, 20, 300,

    Orange, 10, 500

    Banana, 35, 450

    Mango, 15, 350

];

In the above pie chart at the click of a button I need to show what qty of a particular fruit contributed to Sales.

for example in sales Pie chart for Apple the sales is 300 but at the click of a button i need  to show 20 apples contributed to 300.

Similarly for Qty pie chat i need to show what is the sales amount for 10 oranges.

[rwunderlich]

Does it have to be on a click? You can add a second expression that displays the Qty all the time on the Pie.

If you specifically want to show additional information only on a click, check out the "Bar Chart Select" sheet in this example:

Qlikview Cookbook: Conditional Show of Details http://qlikviewcookbook.com/recipes/download-info/conditional-show-of-details/

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

[suryaa30]

Hi Rob, Thanks Much. But I need to show percentage of sales always but switch between sales and qty corresponding to sales on legends or both can  exist simultaneously. Is that possible?  I have added a straight table beside the chart to show the values needed.

[MarcoWedel · Accepted solution]

Hi,

you might as well use grouped expressions that can be switched between using a button within the chart:

hope this helps

regards

Marco