Discussion board where members can learn more about Qlik Sense App Development and Usage.
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
Go to Solution.
1- ((RangeAvg(above(Sum([Nb MP 7 days]),0,5))) / (RangeAvg(above(Sum([Nb WOL 7 days]),0,5))))