topic Re: Calculation in Pivot Table in QlikView

Calculation in Pivot Table

provie98 — Fri, 14 Mar 2014 17:39:35 GMT

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!

Re: Calculation in Pivot Table

rustyfishbones — Fri, 14 Mar 2014 17:41:07 GMT

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

Re: Calculation in Pivot Table

provie98 — Fri, 14 Mar 2014 17:42:28 GMT

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

Re: Calculation in Pivot Table

rustyfishbones — Fri, 14 Mar 2014 17:47:36 GMT

not sure what you mean,

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

Re: Calculation in Pivot Table

provie98 — Fri, 14 Mar 2014 17:55:32 GMT

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.

Re: Calculation in Pivot Table

Gysbert_Wassenaar — Fri, 14 Mar 2014 17:59:10 GMT

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

If not, try reading these two documents:

Re: Calculation in Pivot Table

provie98 — Fri, 14 Mar 2014 18:04:25 GMT

Thanks Mr. Obvious.

Re: Calculation in Pivot Table

rustyfishbones — Fri, 14 Mar 2014 18:05:15 GMT

Using the Excel example you could say

Re: Calculation in Pivot Table

rustyfishbones — Fri, 14 Mar 2014 18:07:09 GMT

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