Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pie Chart with Percentage (Count / total count)

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

  

CustomerplaneTicketdate
aEty12345612/8/2015
bEty98745612/5/2015
cETM12345610/5/2015
dEty56321020/05/2015
eETM8569321422/06/2015
fMAH12121213002/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

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

you can use

count(plane)/count (total plane)

View solution in original post

5 Replies
Anonymous
Not applicable
Author

you can use

count(plane)/count (total plane)

giakoum
Partner - Master II
Partner - Master II

Count(plane) / Count(TOTAL plane)

giakoum
Partner - Master II
Partner - Master II

I am getting old and slow...

alexandros17
Partner - Champion III
Partner - Champion III

Try this expression in your chart:

Count(plane)/Count(TOTAL plane)

let me know

florentina_doga
Partner - Creator III
Partner - Creator III

or

count (plane)

and put check to relative in chart in tag expression