topic Aggregation in aggregation in QlikView

Aggregation in aggregation

Thu, 27 Oct 2011 11:57:36 GMT

Hi,

I want to do something like thi in an expression :

= Avg( {$ <SITUATION_SOL= {"Fermée"}>} min(DATE_CHGT) - max(DATE_CHGT))

DATE_CHGT is a date and SITUATION_SOL the state of an object SOL.

It seems to be impossible tu put aggregation in aggregation.

Does anyone have a solution to do this ?

Thanks

Aggregation in aggregation

swuehl — Thu, 27 Oct 2011 12:37:33 GMT

You have to use advanced aggregation to embed an aggregation into another aggregation, please look into the aggr() function and the help.

The aggr() function needs one or more dimensions to calculate min(DATE_CHGT) - max(DATE_CHGT) for, and without knowing more about your settings and data model, it's hard to help you here.

But anyway, I think you will succeed with using aggr() function.

Regards,

Stefan

Re: Aggregation in aggregation

Wed, 02 Nov 2011 14:05:11 GMT

Thanks for your help.

I have done this : =avg(aggr(max(DATE_CHGT),SOLID)-aggr(min(DATE_CHGT),SOLID))