topic Re: Total % calculation in QlikView

Total % calculation

nareshthavidishetty — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have got the below result in qlikview

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 — Fri, 13 Jan 2017 16:03:14 GMT

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 — Fri, 13 Jan 2017 16:13:57 GMT

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 — Fri, 13 Jan 2017 16:13:57 GMT

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 — Fri, 13 Jan 2017 16:41:19 GMT

could you post your app ?

Anna

pmccaffrey — Fri, 13 Jan 2017 17:46:02 GMT

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%