Average of calculated field

[tahasaleem]

Hello All,

I am trying to calculate the average of a calculated field in Qlikview. The last column 'Mean Difference' in the following table shows what I I am trying to calculate in Qlikview.

Region, Paybales, Receivables and Difference columns are all calculated fields as well.

As shown below, I am trying to calculate the average of  'Difference' column by each region. And the 'Difference' column is the difference between Payables and Receivables columns.

Thanks in advance.

[Taoufiq_Zarra]

Maye be :

=Avg(total <Region> Payables-Receiveables)

[johnca]

Or this;

round(aggr(Avg( Payables-Receivables),Region),1)

This puts the value on the top line by region per your image.

HTH,

John

[tahasaleem]

Thanks Taoufiq and John. Unfortunately both solutions are not working. The column is showing no values. Any other suggestions?

[johnca]

Yes, please supply some raw data without the calculations already done on them. Our solutions work for the data provided so in order to help you need to supply more granular data.