Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
provie98
Contributor II
Contributor II

Calculation in Pivot Table


How can I get a calculation to show me a percentage in this pivot table?  For example, I want the percentage of accounts to total accounts for each group (Closed Account, In Progress, Lost Lead, etc).  The first line would be 7.7% (249 divided by 3232).  Any ideas would be appreciated.  Thanks!

Pivot Table.PNG.png

1 Solution

Accepted Solutions
rustyfishbones
Master II
Master II

Easy now!

Gysbert is one of the best people, if not the best we have on the Qlik Community.

You should check all resources before asking a question.

Don't be so disrespectful!

Regards

Alan

View solution in original post

8 Replies
rustyfishbones
Master II
Master II

Can you try sharing the App, a reduced version of it please

provie98
Contributor II
Contributor II
Author

My apologies.  I posted it in the wrong forum.  I corrected it.  I wasn't creating an app.  Sorry!

rustyfishbones
Master II
Master II

not sure what you mean,

can you share the Qlikview Application or QVW so we can try to help

provie98
Contributor II
Contributor II
Author

Here's an example in Excel.  I'm trying to add the percentage of the Amount vs the Total Amount by eUser_ID and by activity Status.  I think I might have to use Set Analysis since it's in a Pivot Table but I'm not sure.  For example, for Cracker Jack the number percentage is 14.52% (115/792).  Hope this helps.

Pivot Table 2.PNG.png

Gysbert_Wassenaar

Perhaps this discussion can help you: Percentage % Total for Dimension in Pivot Table

If not, try reading these two documents:


talk is cheap, supply exceeds demand
provie98
Contributor II
Contributor II
Author

Thanks Mr. Obvious. 

rustyfishbones
Master II
Master II

Using the Excel example you could say

2014-03-14_1804.png

rustyfishbones
Master II
Master II

Easy now!

Gysbert is one of the best people, if not the best we have on the Qlik Community.

You should check all resources before asking a question.

Don't be so disrespectful!

Regards

Alan