Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
suryaa30
Creator II
Creator II

Pie Chart

Below is my load script.1.JPG

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.

1 Solution

Accepted Solutions
MarcoWedel

Hi,

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

QlikCommunity_Thread_266641_Pic1.JPG

QlikCommunity_Thread_266641_Pic2.JPG

QlikCommunity_Thread_266641_Pic3.JPG

hope this helps

regards

Marco

View solution in original post

3 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

2017-07-05_12-07-52.png

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
Creator II
Creator II
Author

3.JPG

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

Hi,

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

QlikCommunity_Thread_266641_Pic1.JPG

QlikCommunity_Thread_266641_Pic2.JPG

QlikCommunity_Thread_266641_Pic3.JPG

hope this helps

regards

Marco