Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I'm trying to do a pretty straight forward rolling period calculation in Qlikview - at least it's pretty easy to do in Excel
I'm calculating a rolling 4 week period - as per the below - the percentages are the answer i'm trying to achieve
i.e - after the completion of previous week, sum(last 4 weeks)/4
Saturday | ||
0% | ||
0% | ||
0% | ||
1 | 25% | |
25% | ||
1 | 50% | |
50% | ||
1 | 50% | |
1 | 75% | |
1 | 75% | |
75% | ||
50% | ||
25% | ||
0% | ||
1 | 25% | |
1 | 50% | |
1 | 75% | |
75% | COUNT(CD38:CD41)/4 | |
50% | ||
25% | ||
0% | ||
0% | ||
1 | 25% | |
25% | ||
25% | ||
25% | ||
1 | 25% | |
25% | ||
1 | 50% | |
1 | 75% | |
1 | 75% | |
1 | 100% | |
1 | 100% | |
1 | 100% | |
75% | ||
50% | ||
25% | ||
0% | ||
0% | ||
0% | ||
0% | ||
0% | ||
1 | 25% | |
1 | 50% | |
1 | 75% | |
1 | 100% | |
75% |
I'm not sure what the dimensions of the table are or what the field Saturday represents, so this is guess, but perhaps something like:
RangeAvg(Above(Sum(Saturday), 0, 4))
Hi All,
I've used the "Accumulate 4 steps back" function and it seems to work perfectly...
THANKS!!
Please provide detailed calculations as for us it isn't straight forward rolling period calculation 🙂
Attach an excel sample.
Thank you
I'm not sure what the dimensions of the table are or what the field Saturday represents, so this is guess, but perhaps something like:
RangeAvg(Above(Sum(Saturday), 0, 4))
Hi All,
I've used the "Accumulate 4 steps back" function and it seems to work perfectly...
THANKS!!