Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

rmuhammad
Contributor

incorrect Avg roll up

I have a pivot country/ category by service years with avg hourly $rate .... total line not averaging correctly. what could be the problem any suggestions?

avg.PNG

3 Replies

Re: incorrect Avg roll up

Instead 9.34 it should show 11.08 $. Isn't it?? Will you able to provide exxpression you used..

Highlighted

Re: incorrect Avg roll up

May be try with Avg(Aggr(Expression, Dimension/s))

galax_allu
Valued Contributor

Re: incorrect Avg roll up

Avg(Total Aggr(Sum([Service Years]),country_category))

Community Browser