Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
you can use
count(plane)/count (total plane)
Count(plane) / Count(TOTAL plane)
I am getting old and slow...
Try this expression in your chart:
Count(plane)/Count(TOTAL plane)
let me know
or
count (plane)
and put check to relative in chart in tag expression