Discussion Board for collaboration on QlikView Scripting.
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:
it shows the percentage of customers who bought Product A, but not every products.
thanks for your help in advance
Go to Solution.
=Count(Customers)/Count( Total Customers)
Then in the number tab, check 'Show in Percent(%)' .
Interesting, thanks buddy. i had not heard the Total term before.