topic Calculating Weighted Average Days in QlikView

Calculating Weighted Average Days

Fri, 28 Dec 2012 18:30:02 GMT

Hi -

I am looking for an expression that will help me display weighted average between two different date dimensions:

Monthly Report:

Dim1. Created Date

Dim2. Posted Date

Dim 3. Region

12 Month Report:

Dim1. Created Date

Dim2. Posted Date

Dim 3. Region

Thank you!

Re: Calculating Weighted Average Days

Fri, 28 Dec 2012 23:12:51 GMT

Hi zvirina123,

For me "weighted" average would suggest you have another field that holds the weightings, is this the case? If so your expression for each date would look something like

=sum([DateField]*[Weight_Field])/sum([WeightField])

Or are you trying to get the average of the created and the posted dates?

Regards,

Erica