topic grouping of dates to 7 days in QlikView

grouping of dates to 7 days

berryandcherry6 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a script, where it gives dates from particular date to some day.

LOAD

Date(CanonicalDate, 'MM-DD-YYYY') AS CanonicalDate

RESIDENT DateBridge where CanonicalDate >= addmonths (Date(WeekEnd(today(),-1)-56),-12,1) and CanonicalDate <= addmonths (Date(WeekEnd(today(),-1)),-12,1);

Here i need to group dates from addmonths (Date(WeekEnd(today(),-1)),-12,1) to 7 days each. I am using this for dimension in line graph where it has to show start and end date of those 7 days

How could i do this?Please help me

Regards

Re: grouping of dates to 7 days

arulsettu — Thu, 11 Aug 2016 04:02:37 GMT

addmonths (Date(WeekEnd(today(),-1)),-12,1) gives 12-06-2015

addmonths (Date(WeekEnd(today(),-2)),-12,1) gives 05-06-2015

what is the output u expecting?

Re: grouping of dates to 7 days

berryandcherry6 — Thu, 11 Aug 2016 04:17:58 GMT

Hi,

Thanks for reply

my expected output is

if today is 10/08/2016

i need to get previous exact same 10/08/2015.

here my grouping of days should start

10/08/2015 - 04/08/2015 - 1 st week

03/08/2015 - 28/07/2015 - 2nd week

-------

like this it has to group 7 days with start and end date of week. This i am using as dimension for line graph with start and end date of week.

Please help me on this