# New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for
Did you mean:
Highlighted Not applicable

## Total Mode: Expression Total - How to get accurate average

I have a Chart of calculated averages. I wanted to have a Total Row at the bottom and I'm not sure what 'Expression Total' is calculating but it isn't what I need. Since each calculated value uses a different denominator I need to sum the numerators and divide that by the sum of denominators. Merely Averaging the averages will not work. Am I only able to accomplish this by creating my own Total Row with some complicated expressions? If so how do you reference values from other parts of the Chart.

Tags (4)
4 Replies
Highlighted Partner

## Re: Total Mode: Expression Total - How to get accurate average

I guess you may find useful the DIMENSIONALITY() function.

Add it as a expression to see the relationship between cells. The total cells have a zero dimensionality value, so you can then ask IF(DIMENSIONALITY()=0, ...) and set your own total expression.

Hope this helps.

Highlighted Not applicable

## Re: Total Mode: Expression Total - How to get accurate average

So that might work if I'm calculating an average accross rows but what if I'm calculating averages within each column?

Highlighted Partner

## Re: Total Mode: Expression Total - How to get accurate average

In that case maybe you'll need to AGGR() the average expression. 