Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Aggr() problem

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

0 Replies