Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I have source data shown like below:
Created Date | Region | Category | Gross Item | GMV | Net Item | NMV | Net ProductContribution |
22.Sep.2014 | USA | Category1 | 17343 | 653726.5265 | 1179 | 52640.96302 | 1897.348372 |
21.Sep.2014 | USA | Category1 | 17639 | 683777.2766 | 1296 | 59428.21517 | 4088.236366 |
20.Sep.2014 | USA | Category1 | 29494 | 1141787.878 | 1565 | 91394.27327 | 5294.341175 |
19.Sep.2014 | USA | Category1 | 27859 | 1036409.457 | 1767 | 93795.58907 | 5918.346233 |
18.Sep.2014 | USA | Category1 | 26565 | 933426.8913 | 1507 | 78743.72774 | 6075.206899 |
17.Sep.2014 | USA | Category1 | 28794 | 953877.6596 | 1608 | 90701.41638 | 7154.691091 |
16.Sep.2014 | USA | Category1 | 24633 | 789411.4564 | 1242 | 58873.82679 | 7404.235277 |
15.Sep.2014 | USA | Category1 | 19529 | 657768.7264 | 1087 | 51413.46008 | 3013.135526 |
14.Sep.2014 | USA | Category1 | 17707 | 645367.1637 | 1048 | 55941.66801 | 6711.902616 |
13.Sep.2014 | FR | Category1 | 28575 | 1012130.493 | 1639 | 81373.99877 | 7029.309269 |
12.Sep.2014 | FR | Category1 | 27145 | 933660.0882 | 1488 | 89800.27699 | 5650.852355 |
11.Sep.2014 | FR | Category1 | 28002 | 936813.264 | 1484 | 74276.33192 | 5486.880094 |
10.Sep.2014 | FR | Category1 | 27305 | 893464.8142 | 1445 | 75696.93162 | 6956.275582 |
09.Sep.2014 | FR | Category1 | 23763 | 769488.4409 | 1140 | 61850.86473 | 5927.497968 |
08.Sep.2014 | FR | Category1 | 19211 | 651903.7122 | 986 | 47502.99689 | 4604.901628 |
07.Sep.2014 | FR | Category1 | 19422 | 726190.6747 | 1061 | 54745.50161 | 3598.460155 |
06.Sep.2014 | FR | Category1 | 30549 | 1037455.495 | 1344 | 74399.3746 | 6023.19886 |
05.Sep.2014 | FR | Category1 | 29097 | 1115163.128 | 1413 | 71793.67708 | 5943.062865 |
04.Sep.2014 | FR | Category1 | 35597 | 1130421.619 | 1652 | 79694.64002 | 6527.587398 |
My aim to create the pivot table report for past days based on current selection of the created date filter like shown below:
Region | Category | NMV | NMV Last 7 days | NMV L8-14 days | NMV L15-21 days | NMV Last 28 day |
AUS | Category1 | 979972.7465 | ||||
AUS | Category2 | 1984983.704 | ||||
CA | Category1 | 1381436.846 | ||||
FR | Category1 | 711134.5942 | ||||
FR | Category2 | 91781.71974 | ||||
GER | Category2 | 422638.934 | ||||
NZ | Category1 | 57141.45981 | ||||
NZ | Category2 | 950894.9209 | ||||
NZ | Category3 | 827510.1478 | ||||
USA | Category1 | 632933.1395 |
I have attached my sample qvw file along with data source.
I would be really grateful if you advise how to fix this issues.
Regards
Robert
Hi,
Check if this helps
http://community.qlik.com/blogs/qlikviewdesignblog/2014/06/06/dynamically-selecting-timeframes
regards
ASHFAQ