You can use extension to select the date range , attaching here see if it is usefull and fulfilling your requirement..
SenseDateRangePicker-master.zip 608.0 K
Thank you for the reply.
Below is my actual requirement.
1) I am displaying sum(sales) for several US regions using a bar chart.
2) I want to add a filter on Order Date field.
3) I should have one filter that should be displayed as a date picker for selecting StartDate and another filter that should be displayed as a date picker for selecting EndDate.
4) I will store these two values in two variables and will use these variables to filter actual visualization.
Hi Ravi - I agree with Mark as the simplest way to do this - there is an example in this video at the 10 min mark: Understanding the Master Calendar (video)
Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.
I had the same requirement and this is what I did.
1. Create 2 variables:
Set vFromDate = Only(FromDate);
Set vToDate = Only(ToDate);
2. Load From and to dates:
LET vMin = Num(MakeDate(1999,01,01));
LET vMax = Num(Today()+30);
LOAD Date($(vMin) + RowNo() -1) as FromDate
While Date($(vMin) + RowNo() -1) < Date($(vMax));
LOAD FromDate as ToDate Resident FromDates;
3. Use Set Analysis to filter your data:
Hope this helps.
Thank you very much. The work around you suggested is working fine and it is what actually I am looking for, but instead of selecting the date from date values I would like to select the date from a date picker calendar graphic. I mean, when I click on the from date filter, it should display a calendar graphic from which I have to choose date, month and year. I heard that this can be achieved by using qWidget extension, but unfortunately I don't have access to download it.
It would be great if you or anyone can grant me access to download qWidget or please send me qWidget as a zip file to my mail id firstname.lastname@example.org.
there is quite neat extension "FieldUI"
Then you can point to your date field and use dropdown option. It has a setting to use "Always one selected value" as well as "Default value"
Depends on amount of data it is better to apply selection on field rather than using variables which will go against current selection. Solutions suggested by other guys will work very well and if you dont want to use extensions they are the best.
Hope this helps