topic Re: Help: AVG on aggregate in QlikView

Help: AVG on aggregate

Anonymous — Wed, 23 Mar 2016 02:06:25 GMT

Hi Expert,

May i know what should i write in order to get average of ACTUAL_MFG_TIME, when i change "Sum" to "Avg" and the figure go wrong. I have no idea what is going on.

=Sum(Aggr(if(($(e_Actwip_Day)>=$(vToggle)),Sum({<REPORT_DATE = {">=$(=Date(Today()-30))<=$(=Date(Today()-1))"},CAL_GROUP={'D'}>}ACTUAL_MFG_TIME),0), Date_DDMMM,PC_IE_REPORT_GRP))

Thanks for the help in advance.

Joycelyn

Re: Help: AVG on aggregate

Gysbert_Wassenaar — Wed, 23 Mar 2016 08:13:10 GMT

Do you want a sum of averages or an average of sums? In other words should the inner sum be replaced with avg or the outer sum?

Re: Help: AVG on aggregate

sunny_talwar — Wed, 23 Mar 2016 08:13:19 GMT

What exactly are you trying to do? Can you provide some more context?

Re: Help: AVG on aggregate

Anonymous — Thu, 24 Mar 2016 01:21:22 GMT

Hi Guys,

In short, i am looking for

1. an average of actual_mfg_time

2. WIthin condition of

- Last 30 days

- Calg_group='D'

- $(e_Actwip_Day)>=$(vToggle)

3. Group by

- Date_DDMMM

- PC_IE_REPORT_GRP

I am not sure how to write in term of average. Sum is working fine for me.

Thanks.

Re: Help: AVG on aggregate

sunny_talwar — Thu, 24 Mar 2016 10:22:53 GMT

So do you have Date_DDMMM and PC_IE_REPORT_GRP as dimension or do you have more dimensions then these? If these are the only two dimensions in your chart then I would just use Avg() with all your above conditions.