Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
arixooo123
Creator III
Creator III

showing percentage instead of numbers in charts

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

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Try like:

=Count(Customers)/Count( Total Customers)

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

View solution in original post

2 Replies
tresesco
MVP
MVP

Try like:

=Count(Customers)/Count( Total Customers)

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

arixooo123
Creator III
Creator III
Author

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