Weighted average in a straight table

Sun, 13 Nov 2011 22:06:45 GMT

Hi,

I want to create a weighted average in the totals row on a straight table. Basically we want to create a sum product of two columns and divide by sum of one column. Is it possible in qlikview?Thanks

Weighted average in a straight table

swuehl — Sun, 13 Nov 2011 22:37:46 GMT

Try something like

=if(dimensionality()=0,sum(aggr(FIELD1*FIELD2,DIMENSION))/sum(FIELD1), YOURROWEXPRESSION))

where sum(aggr(FIELD1*FIELD2,DIMENSION))/sum(FIELD1) is calculating the weighted average of FIELD2 weighted by FIELD1, and DIMENSION is your chart dimension (if you have more than one,
you need to specify all comma separated).

YOURROWEXPRESSION is the expression you want to show for the table rows.

If you don't want it different, you just can state

=sum(aggr(FIELD1*FIELD2,DIMENSION)) / sum(FIELD1)

Hope this helps,

Stefan

topic Weighted average in a straight table in QlikView

Weighted average in a straight table

Weighted average in a straight table