[ASK] how to sum last several weeks grouped by selected date

[rendiyan]

Dear QlikView Master,

i have a client that need to sum last several weeks per selected date.

So let's say user select Oct 25th (Wednesday) and 26th (Thursday) 2017, so QlikView have to sum the last 8 wednesday start from 25th october and the last 8 thursday from 26 2017.

Simulation will be like below :

Normal last 8 weeks :

In below chart i sum quantity from end date (04/24/2017)

my expression like :

sum({<Year=, Quarter=, Month=, Week=, CalDate=

{'>=$(=date(daystart(vEndDate, -$(vDayParam)*7)))'}*{'<=$(=date(daystart(vEndDate)))'}>}

Quantity)

Expected last 8 weeks :

Client expected is that QlikView Only sum like below :

Description of client like :

1. Selected date will be dimension to show in Chart.

2. Dimension Caldate (04/24/2017) means QlikView will sum the last 8 weeks monday only.

3. Dimension Caldate (04/23/2017) means QlikView will sum the last 8 weeks sunday only.

4. Dimension Caldate (04/22/2017) means QlikView will sum the last 8 weeks 8 saturday only.

5. Dimension Caldate (04/21/2017) means QlikView will sum the last 8 weeks 8 saturday only.

And my question is, is that achieveable with QlikView?

if yes, how to achieve that?

Many many big thank you,

Best Regards,

*Note : value in image 1 and 2 are not related.

[sunny_talwar]

Would you be able to share a sample and based on the sample provided, would you be able to provide the expected output?