Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Adding a % in a pivot table

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

Tags (1)
1 Solution

Accepted Solutions

Re: Adding a % in a pivot table

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


talk is cheap, supply exceeds demand
5 Replies
Not applicable

Re: Adding a % in a pivot table

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%

Not applicable

Re: Adding a % in a pivot table

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.

Not applicable

Re: Adding a % in a pivot table

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

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


talk is cheap, supply exceeds demand
Not applicable

Re: Adding a % in a pivot table

Thanks a lot... that worked :-)

Community Browser