Expression to Calculate average

yvonne-c — Thu, 28 Jan 2016 15:35:03 GMT

Hi,

I am trying to calculate the average figure from the attached chart to go in a text box

This is the expression used in my chart, any help on how I calculate the average figure from it?

Sum({<[Farm ID]=,[Target Weight]={600}>}Aggr(Sum({<[Farm ID]=>}Quantity)/only({<[Farm ID]=>}[Calculated Cow Course])/only({<[Farm ID]=>}[No Cows]),Product,[Farm ID]))

Thanks

Re: Expression to Calculate average

swuehl — Thu, 28 Jan 2016 19:39:43 GMT

Would be easier to answer with more context provided, the dimensions in your chart you've used, some details about the data model, how you calculcated the average line.

Maybe (probably not the best solution) something like

=Avg(<[Farm ID]=,[Target Weight]={600}>}

Aggr(

Sum({<[Farm ID]=,[Target Weight]={600}>}Aggr(Sum({<[Farm ID]=>}Quantity)/only({<[Farm ID]=>}[Calculated Cow Course])/only({<[Farm ID]=>}[No Cows]),Product,[Farm ID]))

, YourChartDimensionField(s)CommaSeparated

))

topic Expression to Calculate average in QlikView

Expression to Calculate average

Re: Expression to Calculate average