topic Re: Pie Chart in QlikView

Pie Chart

suryaa30 — Wed, 05 Jul 2017 18:58:35 GMT

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.

Re: Pie Chart

rwunderlich — Wed, 05 Jul 2017 19:11:03 GMT

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

Re: Pie Chart

suryaa30 — Wed, 05 Jul 2017 19:25:34 GMT

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.

Re: Pie Chart

MarcoWedel — Wed, 05 Jul 2017 23:33:13 GMT

Hi,

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

hope this helps

regards

Marco