Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
you might as well use grouped expressions that can be switched between using a button within the chart:
hope this helps
regards
Marco
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
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.
Hi,
you might as well use grouped expressions that can be switched between using a button within the chart:
hope this helps
regards
Marco