How to get data from chart within date range?

[#1]

Hi,

I have chart data in qvw. All I need is filter on dates. I need to run report every Tuesday.

for eg: if I run the report on 19/05/2015. the data in chart should show from three Tuesdays back. i,e it should show from 28/04/2015 to 11/05/2015. this should be happen every Tuesday.

so, if I run the report on next Tuesday the data should show from 05/05/2015 to 18/05/2015 and so on for every week.

The Date field have values from 2006 to 2015

would it be possible to do this using any variable? or in script?

Please can anyone  suggest me how to do this.

Thanks.

[sunny_talwar]

Hey Amelia, would you be able to share a sample?

Best,

Sunny

[robert_mika]

If you run the report on Wednesday should it show from last Tuesday back or from Wednesday 3 weeks back?

[#4]

if I run on Wednesday it should show from three Wednesdays back To last Tuesday.

[#5]

see attached.

[#6]

is it possible to do this? let me know please.

[sunny_talwar]

Do you want to remove any data that isn't in that range or do you want to make a selection in that particular range or do you have a specific chart you want to see for that range???

Best,

Sunny

[antoniotiman]

Hi Amelia,

see attachment.

Regards,

Antonio

[#9]

I want to make a selection in that particular range.

[#10]

Thanks. I have used this. it is not showing data within date range instead showing all values. do I need to change anything?