Aggr() problem

Wed, 22 May 2013 12:44:36 GMT

Hi, just a simple question about the aggr() function.

I try to create an aggregation of the following expression :

sum

(RAMA_COUNT)/count(distinct {<TYPE={RAMA}>} Hour)/[Nombre de postes]

which calculates the number of type <RAMA> every hour per operator in a month(as dimension in a graphe). It works well and draws the line.

However, when I want to calculate the max and the min of this expression, I have to create an aggregation like:

aggr

(sum(RAMA_COUNT)/count(distinct {<TYPE_HIS={RAMA}>} Hour)/[Nombre de postes],Month)

and this gives different results, and I can't calculate the right min and max.....

Could anyone help !!!

THANKS SO MUCH

topic Aggr() problem in QlikView