topic Problems with the average of an expression in QlikView

Problems with the average of an expression

Wed, 02 Feb 2011 17:19:54 GMT

I want to calculate the average of this expression (below).

(Sum({$<[Bokslut (KSEK)]={'Resultat efter finansnetto'}>} Bokslut)) /

(sum({$<[Bokslut (KSEK)]={'Omsättning'}>} Bokslut))

I need the average of the total. I have tried a lot of different varieties with TOTAL and Avg. Avg(TOTAL.......). But with no success!

matt_crowther — Wed, 02 Feb 2011 18:29:32 GMT

I amy be missing something but I'd try:

((Sum({$<[Bokslut (KSEK)]={'Resultat efter finansnetto'}>} Bokslut)) / (sum({$<[Bokslut (KSEK)]={'Omsättning'}>} Bokslut))) /

((count({$<[Bokslut (KSEK)]={'Resultat efter finansnetto'}>} Bokslut)) +

(count({$<[Bokslut (KSEK)]={'Omsättning'}>} Bokslut)))

Simply the sum of your expression divided by the number of values that are contained in that expression.

Hope that helps,

Matt - Visual Analytics Ltd

Fri, 04 Feb 2011 00:25:32 GMT

Hi,

Have you tried using the aggr() function to get an average. Something like -

Avg(aggr((Sum({$<[Bokslut (KSEK)]={'Resultat efter finansnetto'}>} Bokslut)) /

(sum({$<[Bokslut (KSEK)]={'Omsättning'}>} Bokslut)),SomeField))

You will need to replace the 'SomeField' value with an appropriate field to aggregate over.

I hope this helps

Thanks

Nick