topic Re: Need Help? in QlikView

Need Help?

paulwalker — Wed, 21 Jan 2015 16:40:52 GMT

HI Community,

How to calculate last 7 days data... based on selection.

scripting and layout..

PFA,

maxgro — Wed, 21 Jan 2015 16:48:46 GMT

sum({$<Year=,Month=,Day=,date={">=$(=date(max(date)-7))<=$(=date(max(date)-0))"}>} cost)

PFA

rubenmarin — Wed, 21 Jan 2015 16:53:34 GMT

Hi Paul, you can flag last 7 dates, adding to the script:

Left Join (Test)

First 7 LOAD date, 1 as _IsLast7Days

Resident Test Order By date desc;

Then you can use this in graph expression:

sum({<_IsLast7Days={1}>} cost)

its_anandrjs — Wed, 21 Jan 2015 17:00:35 GMT

Hi,

Try to write

sum({<Year={'$(=Max(Year))'}, Day={'>=$(=Max(Day)-7) <=$(=Max(Day)) '} >} cost)

Regards

Anand

its_anandrjs — Wed, 21 Jan 2015 17:06:41 GMT

For exactly last 7 days try this

sum({<Year= {'$(=Max(Year))'}, Day={'>$(=Max(Day)-7) <=$(=Max(Day)) '} >} cost)

Regards

Anand

paulwalker — Wed, 21 Jan 2015 17:42:23 GMT

Hi Anand,

is it possible write in script level..???