Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team
I have list box in that have around 4 years data that is 2009-Jan-01 to 2012-Dec-01.
Requirement is i wanted to show the dates Start date 2010-Jan-01 End date 2012-july-13 respectively.
below screens are my Start date and End dates
output needs to be below screen
Hi,
How do you want to show it? Based on user Input ?
It is not clear.
If you just want to show Min and Max of a selected date range that you can use Min and Max function.
Hi,
You have to use Calendar objects and assign the variables to it. Also you have to use this variables in the set analysis expression.
Check this link hope it helps you.
Regards,
Jagan.
Hi,
Please find attached file for solution.
Regards,
Jagan.
i dnt have to access qvw files because i have been using personal edition so can send me thedata
Hi,
Create two variables
vMinDate & vMaxDate
Now create two Calendar objects and assign this two variables to each of the object. In Number tab select Date option.
Now in all your charts you have to use the expression like below
=Sum({<Date={'>=$(=Date(vMinDate))<=$(=Date(vMaxDate))'}>}Sales)
Regards,
Jagan.
maybe this .qvw is personal edition compatible
The Basics about Dates, Date Ranges and Set Analysis
Example for start end date with calendar objects is at the top