| Date | Sales | Sales in past 3 days | Sales from 6-4 days in past | in pastSales from 9-7 days in past |
|---|
| 01.09.2012 | 10 | 10 | 0 | 0 |
| 02.09.2012 | 5 | 15 | 0 | 0 |
| 03.09.2012 | 6 | 21 | 0 | 0 |
| 04.09.2012 | 10 | 21 | 10 | 0 |
| 05.09.2012 | 7 | 23 | 15 | 0 |
| 06.09.2012 | 4 | 21 | 21 | 0 |
| 07.09.2012 | 2 | 13 | 21 (from 04.09.2012 to 06.09.2012) | 10 (from 01.09.2012 to 03.09.2012) |
| 08.09.2012 | 1 | 7 | 23 | 15 |
| 09.09.2012 | 3 | 6 | 21 | 21 |
| 10.09.2012 | 5 | 9 | 13 | 21 |
| 11.09.2012 | 8 | 16 | 7 | 23 |
| 12.09.2012 | 9 | 22 | 6 | 21 |
| 13.09.2012 | 7 | 24 | 9 | 13 |
| 14.09.2012 | 10 | 26 | 16 | 7 |
| 15.09.2012 | 5 | 22 | 22 | 6 |
Sample Data
The first two columns represent the actual data sample and the entire table ablove is the expected output in qlikview. Pleas help to achieve this output in Qlikview with set analysis or any other implementation
.png "Luminary Alumni"){kind=icon}