topic Re: AVG on formula in QlikView

AVG on formula

Anonymous — Sun, 15 Sep 2013 11:17:18 GMT

I have a formula field that looks like this “sum(a)+sum(b)/sum(c)”

I need to do avg on this formula without changing the field formula.

Tried avg(formula) it didn’t work. Any ideas ??

Re: AVG on formula

ariel_klien — Sun, 15 Sep 2013 12:26:50 GMT

Hi,

Try to do this on the script level like:

Load ...

sum(a)+sum(b)/sum(c) as formula

from....

and in the expression put avg(formula)

Ariel

Re: AVG on formula

whiteline — Sun, 15 Sep 2013 12:36:33 GMT

Hi.

Avg() means that you have a set of results of your formula. Suppose that you want to get the average of a set that is provided by dimension Dim. Then you could write an expression:

=avg(aggr(fourmula, Dim))

Re: AVG on formula

Jason_Michaelides — Sun, 15 Sep 2013 13:15:46 GMT

Have you tried Avg((a+b)/c)?

Re: AVG on formula

rajeshvaswani77 — Sun, 15 Sep 2013 13:37:28 GMT

Have you missed out the brackets in your formula?

(sum(a)+sum(b))/sum(c)

thanks,

Rajesh Vaswani

Re: AVG on formula

lironbaram — Sun, 15 Sep 2013 13:46:19 GMT

hi as far as i know

if you want to do an average on sum function you need to define the dimension on which you calculate the average

let say you want to do average for customer then you'll expression will look

avg(aggr(Formula,Customer))