topic showing percentage instead of numbers in charts in QlikView

showing percentage instead of numbers in charts

arixooo123 — Mon, 15 Sep 2014 04:23:45 GMT

hello dears,

i got a question, i already have a bar chart which shows the number of customers for each products,

the script for this chart is so easy, i have added Products field as dimension, in the expression i wrote count(Customers).

but i want to see the percentage instead of numbers. if i write the script like this:

count({<Product={A}>}Customers)/Count(Customers)

it shows the percentage of customers who bought Product A, but not every products.

thanks for your help in advance

tresB — Mon, 15 Sep 2014 04:28:44 GMT

Try like:

=Count(Customers)/Count( Total Customers)

Then in the number tab, check 'Show in Percent(%)' .

arixooo123 — Mon, 15 Sep 2014 04:32:01 GMT

Interesting, thanks buddy. i had not heard the Total term before.