topic Re: Need help with avg in QlikView

Need help with avg

Fri, 31 Jul 2015 20:36:19 GMT

Hi Guys,

I need your help on how I can take an average of the days spent on resolving a ticket.

I want to get this by using only an expression.

For example for this table what I want to get is the 21,666 result , which is the sum of the average time spended by state of resolving a ticket.

Thanks In Advance,

Cristian.

jaimeaguilar — Fri, 31 Jul 2015 20:54:28 GMT

Hi,

you may need to use aggr as it is compound calculation (just like you said it is the sum of the averages),

take a look at the attached example

regards

robert_mika — Fri, 31 Jul 2015 21:48:32 GMT

=sum(aggr( avg(Days),state))

Feeling Qlikngry?