Pie Chart with Percentage (Count / total count)

[#1]

Hi,

i have been trying to do something on qlikview on a pie chart.

i have attached a sample file.

I have 6 rows in a tale

like

Customer	plane	Ticket	date
a	Ety	123456	12/8/2015
b	Ety	987456	12/5/2015
c	ETM	123456	10/5/2015
d	Ety	563210	20/05/2015
e	ETM	85693214	22/06/2015
f	MAH	1212121	3002/2015

i want to make a pie chart in qlikview with the dimension plane and expression as count (plane).

i want to find the proportion for each plane by the total count. so my out put will be

ETY= 3/6= 50%

ETM = 2/6 = 33.33%

ETM = 1/6= 16.67 %

Any body help me to achieve this..

Thanks

[Anonymous · Accepted solution]

you can use

count(plane)/count (total plane)

[giakoum]

Count(plane) / Count(TOTAL plane)

[giakoum]

I am getting old and slow...

[alexandros17]

Try this expression in your chart:

Count(plane)/Count(TOTAL plane)

let me know

[florentina_doga]

or

count (plane)

and put check to relative in chart in tag expression