topic Re: Pie Chart with Percentage (Count / total count) in QlikView

Pie Chart with Percentage (Count / total count)

Tue, 07 Jul 2015 13:11:51 GMT

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

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 — Tue, 07 Jul 2015 13:15:53 GMT

you can use

count(plane)/count (total plane)

giakoum — Tue, 07 Jul 2015 13:17:10 GMT

Count(plane) / Count(TOTAL plane)

giakoum — Tue, 07 Jul 2015 13:17:41 GMT

I am getting old and slow...

alexandros17 — Tue, 07 Jul 2015 13:17:59 GMT

Try this expression in your chart:

Count(plane)/Count(TOTAL plane)

let me know

florentina_doga — Tue, 07 Jul 2015 13:32:40 GMT

count (plane)

and put check to relative in chart in tag expression