Average

[#1]

Hi,

I have the following table on qlikview. I am only concerned with the 'Total' row. Total # Apps is correct. However under Total row, Avg Decision Time Hrs (3.80) and Apps Decisioned per Day (3.09) are not correct. Currently Total Average for the above two columns is simple. It's taking average of all rows. But the reality is that each staff has different no of applications Therefore the average 3.80 & 3.09 are wrong. Any way to find correct Total Average?

Staff Name	# Apps	Avg Decision Time (Hrs)	Apps Decisioned per Day
A	407	2.45	5.99
B	422	3.18	5.94
A	376	3.16	5.30
B	301	3.88	4.85
A	271	2.89	4.30
B	261	4.24	4.08
A	182	4.37	3.87
B	195	4.43	3.82
A	217	4.17	3.50
B	189	2.45	3.15
A	198	6.33	2.96
B	207	6.23	2.80
A	164	4.33	2.52
B	51	1.71	2.43
A	41	0.50	1.71
B	1	0.52	1.00
A	1	4.12	1.00
B	1	2.20	1.00
A	8	6.27	0.80
B	20	8.56	0.80
Total	3,513	3.80	3.09

[Gysbert_Wassenaar]

You want the average of the averages? Try avg(aggr( ...avg_decision_time_expression_here... , [Staff Name]))

[agomes1971]

Hi,

be more explicit by the way you want the calculation done...

Regards

André Gomes

[#4]

Yes I want to take average of averages. however currently they way its doing now is not correct

[#5]

Hi Andre,

I want to get average of all averages by taking each average based on their applications. Currently it just sums up all averges and divide by numner of staffs which is wrong.

[#6]

Hi Gsybert,

Individual average for each staff is correct however the issue is only under Total. How can I write the above expression to only get under Total average??

[#7]

Hi Shoaib,

try

If( Dimensionality()=0,

avg(aggr( [avg_decision_time_expression], [Staff Name]))

,[avg_decision_time_expression]

)

and replace with your avg expression.

If that doesn't work maybe post up an example app

hope that helps

Joe

[kji]

You should be using "Expression Total" (Total Mode on the Expressions tab), but it sounds like you currently have it set to "Average of Rows".

[#9]

Hi Joe,

I am using "Average of Rows" under Total Mode. But it's not right way. How can I put your expression because there is no option to write expression under Total Mode

[MarcoWedel]

Please post your expected result and the way you calculated it.