topic Re: Average vs Total Sum in QlikView

Average vs Total Sum

javier_florian — Thu, 22 May 2014 22:25:20 GMT

Hi Everyone,

This case may seem a simple question, but it has a trick that I have not been able to correct, I have the sum of percentages and I compare it with a fixed value (blue color) in each record and I have no difference however in total if I have differences.
In excel throws me the same result, divide the second column on the first and throws me the correct value, but to make full (bold) I re-throw the same difference.
What can I do there?

-Regards

Re: Average vs Total Sum

SergeyMak — Fri, 23 May 2014 01:10:36 GMT

Please share a sample in Excel or qvw

Re: Average vs Total Sum

Anonymous — Fri, 23 May 2014 01:32:19 GMT

The third column, where you divide second by first, is correct.

The blue bold ("total") is average of the above blue rows, and it doesn't make sense. Example, to illustrate the reason:

Sales of apples in May is $10 and oranges is $30. Share of apples is 25%

Sales on apples in June is $10,000 and oranges is $10,000 too. Share of apples is 50%.

Can you say that average share of apples in two months is 37.5%? Obviously not, because the June amounts are much large then in May. Without any calculations it is clear that it is close to 50% because May values are insignificant comparing to June.

Hope it helps...

Re: Average vs Total Sum

Fri, 23 May 2014 04:36:57 GMT

Agree with Michael!