Total % calculation

[nareshthavidishetty]

Hi,

I have got the below result in qlikview

Nevada	140	0.00%
Nevada	196	71.40%
Nevada	208	87.50%

Total % = 48%

But when i have tried to validate it in excel it showing avg of around 54%.

My calculation is right.

Please let me know how qlikview calculating the % total.

Logic:

num((sum({<Date={$(varMaxDate)},flag={'eSign'},Category={'Complete'}>} Sales))

/(sum({<Date={$(varMaxDate)},flag={'Wet Sign'}>} Sales)+sum({<Date={$(varMaxDate)},flag={'eSign'},Category={'Complete'}>} Sales)

+sum({<Date={$(varMaxDate)},flag={'eSign'},Category={'Not Complete'}>} Sales))*100, '#,##0'))

Thanks..

[sunny_talwar]

Where are you seeing 48%? Where do you want 54%? I have no idea what and where you are looking to get, whatever is that you are looking

[vishsaggi]

Sunny, we don't need single quotes for that variable varMaxDate like { '$(varMaxDate)' }

and there is an extra bracket ) at the end, I hope Naresh is aware of it.?

[nareshthavidishetty]

Hi Sunny,

Qlikview is giving 71.40%+87.50%+0%/3=48%

but i got i excel avg(71.40%+87.50%+0%)=54%

I need to know is my calculation in qlikview is right or not.

Thanks..

[annafuksa1]

could you post your app ?

Anna

[pmccaffrey · Accepted solution]

In Excel you are taking an Average of an Average.

In QlikView it's taking the true Sum of one divided by the Sum of another.

For instance...

Group	Sales	Opp	%
A	78	130	60%
B	12	17	70.59%
C	3541	3722	95.14%

True Average would be sum(Sales) / Sum(Opp)  = 93.85%

In Excel though, Average(60%,70.59%,95.14%) = 75.24%