topic Re: Wrong total of percentages in a pivot table in Francophones

Wrong total of percentages in a pivot table

Wed, 15 Jul 2015 10:27:29 GMT

Hello,

I have a problem with the total of percentages in a pivot table.

The total is wrong, normally the total has to be 100% for all columns.

I'm new to QlikView, can anybody help me to fix it?

Attatched you find the application.

Best regards.

Re: Wrong total of percentages in a pivot table

MK_QSL — Wed, 15 Jul 2015 10:34:47 GMT

Use 2nd expression as

SUM(NOMBRE)/SUM(TOTAL <Type, Compteur> NOMBRE)

Re: Wrong total of percentages in a pivot table

sunny_talwar — Wed, 15 Jul 2015 10:36:09 GMT

Or try this for your second expression:

Sum(Aggr(sum(NOMBRE)/sum(NB_FRANCE), DR, [CODE PE], POIDS1, Type, Compteur))

Re: Wrong total of percentages in a pivot table

Wed, 15 Jul 2015 10:52:07 GMT

Thank your for the reply.

The problem of this solution is that when I select a specific DR, %France changes value.

I don't want it to change value.

Re: Wrong total of percentages in a pivot table

MK_QSL — Wed, 15 Jul 2015 10:53:01 GMT

SUM({<DR = >}NOMBRE)/SUM({<DR = >}TOTAL <Type, Compteur> NOMBRE)

Re: Wrong total of percentages in a pivot table

Wed, 15 Jul 2015 11:08:07 GMT

Thank you very much it works.

I have just modified it a little like this:

SUM(NOMBRE)/SUM({<DR = >}TOTAL <Type, Compteur> NOMBRE)

Because when i select a specific DR, i want to display only the lines of that DR and in this case the total has to be the sum the displayed lines which is different than 100% (normal).

I tested also the solution proposed by sunindia, one pb with it is that when i delete all selections, the totals are a little more than 100%.

Best regards.

Re: Wrong total of percentages in a pivot table

MK_QSL — Wed, 15 Jul 2015 11:10:10 GMT

Please close the thread by selecting appropriate answer.

Re: Wrong total of percentages in a pivot table

sunny_talwar — Wed, 15 Jul 2015 11:13:00 GMT

I agree that with no selection the percentages total is going beyond 100%, but that's just a function of what you are using to calculate your %. When all cleared %France is showing 100.65% and Excel export shows that the sum of all the rows is also 100.65%.

Not saying that my solution is the right one, just pointing out that you may or may not want to fix the issue

Also, if the issue has been resolved, would you be kind enough to mark Manish's answer as correct.

Best,

Sunny