Last 7 Days values

[khanashique]

Hi Experts,

Below is the table, from which i need to prepare a chart, that will show only last 7 days data/value. 

Item	Date	Value
Books	10-Nov-18	3021.15
Books	11-Nov-18	3482.1
Books	12-Nov-18	2194.25
Books	13-Nov-18	1992.7
Books	14-Nov-18	1036.75
Books	15-Nov-18	2785.45
Books	16-Nov-18	2258.7
Books	17-Nov-18	2355.2
Books	18-Nov-18	1879.9
Pen	19-Nov-18	1313.4
Pen	20-Nov-18	3146.05
Pen	21-Nov-18	1246.75
Pen	22-Nov-18	1371.8
Pen	23-Nov-18	2538.9
Pen	24-Nov-18	2344.25
Pen	25-Nov-18	2598.15
Pen	26-Nov-18	2415.85
Pen	27-Nov-18	2292.95
Pen	28-Nov-18	1255.85
Cover	29-Nov-18	0
Cover	30-Nov-18	0
Cover	1-Dec-18	999.5
Cover	2-Dec-18	3882.45
Cover	3-Dec-18	1550.7
Cover	4-Dec-18	1650.75
Cover	5-Dec-18	4218.3
Pencil	6-Dec-18	9519.75
Pencil	7-Dec-18	7942.7
Pencil	8-Dec-18	3665.6
Pencil	9-Dec-18	3655.8
Pencil	10-Dec-18	10833.25

Thanks,

MAK.

[khanashique]

Need a chart which will show data like shown below:

[adamgaox]

Hope u like QlikView.

I'm a big fan.

[mark6505]

Hi,
I would add a flag to the data in script and use that.
IF(TempDate <= TODAY(1) AND TempDate >= (TODAY(1)-7),1) AS F_ROLLING_7,

Then Set Analysis would be
SUM({<F_ROLLING_7={1}>}Value)

Mark

[Gabriel]

Hi,

Try this expression

=SUM({<Date = {"<=$(=MAX(Date))>=$(=Date(MAX(Date)-7))"}>}Value)

[adamgaox · Accepted solution]

Sorry, didn't notice you're sense user.

Please try the zip qvf file.

Dimension:

=If(Date>$(MaxDayMinus7),Date(Date,'dd-MMM-YYYY')&chr(13)&Item,NULL())

Variable MaxDayMinus7:

=Max(Num(Date))-7

[khanashique]

Thanks a lot Adam...