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.

[antoniotiman]

what do You want to see ? where ?

[#3]

I want to seethe data with in date range. I have used the expression. but it is not showing data based on expression.

[sunny_talwar]

See if this helps (PFA)

Best,

Sunny

[antoniotiman]

Add Your expression

[#6]

Thanks. The date range which you used is correct.  is there any way to include

Date(vToday - 21) & '<=' & Date(vToday - 😎

  into chart expression?. so, that it will populate data automatically with out any selection.

let me know please.

[#7]

Count({<Date={">$(=Date(Max(TOTAL Date)-21))<=$(=Date(Max(Date)))"}>} [Yes or No])

[sunny_talwar]

This within your set analysis should restrict the results for those two weeks:

{<Date={"$(='>=' & Date(vToday - 21) & '<=' & Date(vToday - 8))"}>}

[antoniotiman]

Change Count with MaxString