topic Issue with Totaling a Percentage in Pivot Table in QlikView

Issue with Totaling a Percentage in Pivot Table

marc_wintjen — Thu, 15 Mar 2012 14:09:12 GMT

Hi, I have an issue with trying to total a percentage. I've attached an example and I'm trying to show the Sum of 2 Percentage values in a Pivot table. Is it possible to total the values and not display the Dimension that makes up that total (see attached)? If a straight table is a better solution, I'm fine with that as well. Thanks!

Issue with Totaling a Percentage in Pivot Table

Thu, 15 Mar 2012 14:24:47 GMT

Since I am using a PE version so I can not open your report, but I can give you a suggestion.

Try to use "straight table", select "properties"-->"presentation"-->select the dimension you want to hidden-->select the radio box "hide column".

Re: Issue with Totaling a Percentage in Pivot Table

dwh1104 — Thu, 15 Mar 2012 14:25:40 GMT

Please see the attached QVW and let me know if this is what you are looking for.

Thanks,

Dan

Issue with Totaling a Percentage in Pivot Table

jvitantonio — Thu, 15 Mar 2012 14:25:51 GMT

Hi, in your ex. in the second table, you'd like to hide those Products groups which areNULL but still see the sum of the 5 for the NULLS + Company Product Group 1? (in your ex. would be 102.78%)

Issue with Totaling a Percentage in Pivot Table

swuehl — Thu, 15 Mar 2012 14:27:18 GMT

Not really sure if I got your issue correctly, if you want to show the total line value in all lines for that group, you could try something like

=sum(total<Quarter> [Weighted Avg Calc])

as expression, i.e. using the total qualifier with appropriate field list.

Re: Issue with Totaling a Percentage in Pivot Table

jagan — Thu, 15 Mar 2012 14:28:16 GMT

Hi,

Please check the attached file.

Hope it helps you.

Regards,

Jagan.

Issue with Totaling a Percentage in Pivot Table

marc_wintjen — Thu, 15 Mar 2012 14:37:38 GMT

Guys, thanks for your quick response - Moving the Dimensions will not resolve this because I need to only show the Company Products Group 1 or show null values for Products that don't have a Company Product Group. So the final result would look like this:

Customer Group	Market Basket	Year	Quarter	Company Products Group	Calc
Customer 1	Market Basket 1	2010	2010 - Q2	CompanyProduct Group 1	102.78%

Customer 1	Market Basket 1	2010	2010 - Q2	CompanyProduct Group 1	104.86%

Re: Issue with Totaling a Percentage in Pivot Table

jagan — Thu, 15 Mar 2012 14:41:10 GMT

Hi,

Use this expression.

Sum(Aggr(sum([Weighted Avg Calc]),[Customer Group],[Market Basket],Year, Quarter))

Check the attachment.

Regards,

Jagan.

Issue with Totaling a Percentage in Pivot Table

marc_wintjen — Thu, 15 Mar 2012 14:42:08 GMT

Adding a Total within the Sum did give me the right answer but when I hide the Null Company Product Groups, it gives me the wrong total (shows 51.65% vs. 102.78%).

Re: Issue with Totaling a Percentage in Pivot Table

swuehl — Thu, 15 Mar 2012 14:42:17 GMT

I assume your Quarters should differ, so maybe like attached?

Issue with Totaling a Percentage in Pivot Table

marc_wintjen — Thu, 15 Mar 2012 14:59:53 GMT

Awesome - Thanks!