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: 
Not applicable

Wrong total of percentages in a pivot table

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.

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

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

View solution in original post

7 Replies
MK_QSL
MVP
MVP

Use 2nd expression as

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

sunny_talwar

Or try this for your second expression:

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

Capture.PNG

Not applicable
Author

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.

MK_QSL
MVP
MVP

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

Not applicable
Author

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.

MK_QSL
MVP
MVP

Please close the thread by selecting appropriate answer.

sunny_talwar

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%.

Capture.PNG

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