topic Re: creating Pie chart combining 3 cells in QlikView

creating Pie chart combining 3 cells

sayadutt — Wed, 28 May 2014 12:15:31 GMT

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

Wed, 28 May 2014 12:43:40 GMT

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 — Wed, 28 May 2014 12:49:54 GMT

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 — Wed, 01 Mar 2017 18:25:31 GMT

Hi,

Can you share an exemple of your data ?

Regards