Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
what do You want to see ? where ?
I want to seethe data with in date range. I have used the expression. but it is not showing data based on expression.
See if this helps (PFA)
Best,
Sunny
Add Your expression
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.
Count({<Date={">$(=Date(Max(TOTAL Date)-21))<=$(=Date(Max(Date)))"}>} [Yes or No])
This within your set analysis should restrict the results for those two weeks:
{<Date={"$(='>=' & Date(vToday - 21) & '<=' & Date(vToday - 8))"}>}
Change Count with MaxString