Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Avg over fractiles inside of dimensions

Hello

I have the following problem:

I want to calculate the avg inside of the dimension only for values over 10% and under 90%

So in case there are values 1-10, I wat to calculate the avg(2,....,9)

I've managed to calculate when having onla one raw (see screenshot) with the following formula:

=Avg( If((dActVal)>Fractile(Total dActVal,0.1) and (dActVal)<=Fractile(Total dActVal,0.9) ,dActVal))

unfortunately its not working with different dimentions.

(I think I have to do sth like this   aggr(dActVal,Artikelnr,Maschinenennr)  )

Fractile.png

3 Replies
Anonymous
Not applicable
Author

Has nobody an idea??

Anonymous
Not applicable
Author

Avg(Aggr(If(avg(dActVal)>=Fractile(Total <Artikelnr,Maschinenennr> (dActVal),0.1) and avg(dActVal)<=Fractile(Total <Artikelnr,Maschinenennr> (dActVal),0.9),avg(dActVal)),Artikelnr,Maschinenennr))

Using this formula it shows me the correct fractiles (over 2 Dimensions <Artikelnr, Maschinennr>) but the avg is calculate over all values in Artikelnr and Maschinennr...

Im really lost

Anonymous
Not applicable
Author