calculation on slippery weeks

[#1]

Hi community,

I need to do a calculation on slippery weeks in order to make previsions. and I don't know how to do it.

Have see in the snapshot, the calcul is done on Excel, I want to do the same on Qlik Sense.

I tried to use RangeAvg function, but I dont know how to specify the range, an also I think there should be some spécifications in the limits of the fields

Helppp and thanks

[#2 · Accepted solution]

1- ((RangeAvg(above(Sum([Nb MP 7 days]),0,5))) / (RangeAvg(above(Sum([Nb WOL 7 days]),0,5))))