Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the above table I have used the following expression:
RangeSum(Before(Count([Days to pack back]),0,ColumnNo()))
What I need it to now is fill in all the blank rows where data could have been so like a
If(Column = - then match previous column)
However I want it to leave future dates as -
so It should look like it does on excel which is below
| Cumulative Weeks to Pack Back | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 17 |
| Week1 | 0.00% | 50.51% | 61.62% | 65.66% | 66.67% | 66.67% | 69.70% | 69.70% | 70.71% | 70.71% | 70.71% | 70.71% |
| Week2 | 9.89% | 56.04% | 68.13% | 68.13% | 70.33% | 74.73% | 75.82% | 75.82% | 75.82% | 75.82% | 75.82% | 75.82% |
| Week3 | 1.89% | 41.51% | 50.94% | 56.60% | 64.15% | 64.15% | 66.04% | 67.92% | 67.92% | 67.92% | 67.92% | 67.92% |
| Week4 | 3.45% | 62.07% | 75.86% | 79.31% | 79.31% | 79.31% | 79.31% | 79.31% | 79.31% | 79.31% | 79.31% | 79.31% |
| Week5 | 12.50% | 58.33% | 58.33% | 62.50% | 66.67% | 66.67% | 70.83% | 70.83% | 70.83% | 70.83% | 70.83% | 70.83% |
| Week6 | 0.00% | 33.33% | 60.00% | 66.67% | 66.67% | 73.33% | 73.33% | 73.33% | 73.33% | 73.33% | 73.33% | 73.33% |
| Week7 | 7.69% | 69.23% | 76.92% | 80.77% | 84.62% | 84.62% | 88.46% | 88.46% | 88.46% | 88.46% | 88.46% | 88.46% |
| Week8 | 0.00% | 40.00% | 80.00% | 80.00% | 80.00% | 80.00% | 80.00% | 80.00% | 80.00% | 80.00% | 80.00% | 80.00% |
| Week9 | 0.00% | 66.67% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% |
| Week10 | 0.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% |
| Week11 | 0.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% |
| Week12 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% |
| Week13 | 0.00% | 50.00% | 62.50% | 75.00% | 75.00% | 87.50% | 87.50% | 87.50% | 87.50% | 87.50% | 87.50% | |
| Week14 | 8.33% | 50.00% | 50.00% | 50.00% | 50.00% | 50.00% | 50.00% | 50.00% | 50.00% | 50.00% | ||
| Week15 | 20.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | 60.00% | |||
| Week16 | 0.00% | 69.23% | 69.23% | 69.23% | 69.23% | 69.23% | 69.23% | 69.23% | ||||
| Week17 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |||||
| Week18 | 0.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | ||||||
| Week19 | 0.00% | 40.00% | 60.00% | 60.00% | 60.00% | |||||||
| Week20 | 2.27% | 52.27% | 61.36% | 70.45% | ||||||||
| Week21 | 3.13% | 53.13% | 62.50% | |||||||||
| Week22 | 9.30% | 53.49% | ||||||||||
| Week23 | 0.00% |
How would I do this in an expression in Qlik Sense
