creating Pie chart combining 3 cells - Qlik Community

sayadutt · ‎2014-05-28

Hi,

I am new to QV. I have a requirement where I need to create Percentage Pie chart based on 3 cell values.

For example:

1 field = Total Open Defects

2 field = Total Closed defects

3 field = Total Rejected defects

Can you please guide me how can I create a single Percentage Pie chart which will show the Open, Closed and Rejected defects in Percentage.

Thanks

Report Inappropriate Content · ‎2014-05-28

Check out the free training that qlikview offers, it is extremely helpful and can answer this question and probably others that you have as well

its_anandrjs · ‎2014-05-28

Let me i explain to you suppose you have table like

LOAD * Inline

[

DefectType,Value

Open,10

Closed,40

Rejected,60

];

Then create a pie chart

---------------------------------

Dim:- DefectType

Exper:- Sum(Value)

And in Expression properties click on the Relative and then you get percentage chart

marwen_garwachi · ‎2017-03-01

Hi,

Can you share an exemple of your data ?

Regards