Adding a % in a pivot table

[#1]

Hi

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

Kind regards

Flemming

[#2]

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%

[#3]

Hi

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.

[#4]

Hi,

If you want to show % symbol after ant exp use below code.

sum(No_Customers) & '%'

And in numbers tab check show in %

[Gysbert_Wassenaar · Accepted solution]

You can use the total keyword:

=sum(No_Customers)/sum(total No_Customers)

If you don't want to overall total but over a dimension you use something like:

=sum(No_Customers)/sum(total <Status> No_Customers)

or

=sum(No_Customers)/sum(total <Month> No_Customers)

See attached qvw

[#6]

Thanks a lot... that worked 🙂