Discussion Board for collaboration related to Creating Analytics for QlikView.
Kind of a newbie into Qlikview and can't seem to find this answer anywhere else, so i'm hoping some of you can send me in the right direction.
I would like to add a percent in a pivot table showing the percent of customers in each group - compared to the total customers. I have attached a sample doc
Go to Solution.
You can use the total keyword:
If you don't want to overall total but over a dimension you use something like:
=sum(No_Customers)/sum(total <Status> No_Customers)
=sum(No_Customers)/sum(total <Month> No_Customers)
See attached qvw
Go to the chart properties of Pivot table and Use Number tab and change the "Number format Settings" to Fixed to and give 2 as decimal and check the check box Show in Percentage%
Thats a part of the problem, but how do i get QV to measure the total amount of customers inside a group... i have tried with a set analysis but it does not seems to do the trick.
If you want to show % symbol after ant exp use below code.
sum(No_Customers) & '%'
And in numbers tab check show in %
Thanks a lot... that worked :-)