topic Re: Calculate average grouping by continuous values in QlikView

Calculate average grouping by continuous values

moleroalonso — Tue, 03 May 2016 08:06:35 GMT

Hi,

I have a graph table and I need calculate a column on a special way: the values are the average of the values of a previous column called (Diff) grouped by the continuous values of other column (Duration), See an example at the image below:

Currently I am calculating the "Avg. diff" column with this expression:

avg(aggr(

avg(Duracion- (Aggr(Avg(duracionReal), F30_HRAsignada) + TiempoEspera)) /*Calculation of "diff" Column*/

, Duration))

The result is this but it is not the expected result

I tried it using a calculated dimesion but calculated dimesion are not valied in AGGR functions.

¿Any idea?

Best regards,

José María

Re: Calculate average grouping by continuous values

sunny_talwar — Wed, 04 May 2016 02:20:09 GMT

Would you be able to share your application to play around with this? It is difficult to suggest anything without being able to see how the data structure looks like and without trial and erroring it

Re: Calculate average grouping by continuous values

moleroalonso — Wed, 04 May 2016 07:25:29 GMT

Hi,

I finally fixed this problem in the Load Script. I calculated a new field that mark each continuos values with a ID.

The thread can be closed.

Thank very much!