Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi, here's the solution. I hope it helps.
Thanks a lot for the answer. Is it possible to achieve the same results in set analysis ?