Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

calculation on slippery weeks

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

1 Solution

Accepted Solutions
Not applicable

Re: calculation on slippery weeks

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

1 Reply
Not applicable

Re: calculation on slippery weeks

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