topic Re: Adding a % in a pivot table in QlikView

Adding a % in a pivot table

Tue, 05 Mar 2013 09:39:55 GMT

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

Re: Adding a % in a pivot table

Tue, 05 Mar 2013 09:47:48 GMT

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%

Re: Adding a % in a pivot table

Tue, 05 Mar 2013 10:26:11 GMT

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.

Re: Adding a % in a pivot table

Tue, 05 Mar 2013 13:30:13 GMT

Hi,

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

sum(No_Customers) & '%'

And in numbers tab check show in %

Re: Adding a % in a pivot table

Gysbert_Wassenaar — Tue, 05 Mar 2013 13:35:25 GMT

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)

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

See attached qvw

Re: Adding a % in a pivot table

Tue, 05 Mar 2013 14:12:39 GMT

Thanks a lot... that worked 🙂