Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
arixooo123
Contributor

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

Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

Re: showing percentage instead of numbers in charts

Try like:

=Count(Customers)/Count( Total Customers)

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

2 Replies
MVP
MVP

Re: showing percentage instead of numbers in charts

Try like:

=Count(Customers)/Count( Total Customers)

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

arixooo123
Contributor

Re: showing percentage instead of numbers in charts

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

Community Browser