Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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.

4 Replies
diegofcaivano
Contributor

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.

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?

diegofcaivano
Contributor

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

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

Please attach a mock application with this issue so we can help you further.

whiteline
Honored Contributor II

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

Hi.

If it possible with your data model: =Sum(Numerator)/Sum(Denominator)

This usually is a correct way to aggregate on both dimension and total levels.

Community Browser