Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have two date dimensions by name starts date and end date , i want to use both of this in a slider (Scale range ) how do i do that .
Can some one help me please
Thanks in Advance
hi ,
You would be having the date field in your Db Tables .You can use Min (date) as start date or Max (date) as End date .
Start date : MIn(Date)
End Date : Max(Date ) or Today().
if u dnt have , then use Make date () function to create a date.
Regards,
Saurabh
Please see attached qvd. MV
Hey MV thanks for the reply
but my requirement is to have one slider for both the dates , not two , i hope u undesrtand now , i want to get start date and end date in a single slider
Create a single field using both and then use i as a calendar date
Data:
LOAD F1,Date(Startdate) as Startdate, Date(Enddate) as Enddate INLINE [
F1, Startdate, Enddate
1, 01/01/2014, 01/10/2014
2, 01/02/2014, 01/20/2014
3, 01/03/2014, 01/13/2014
4, 01/04/2014, 01/24/2014
];
DateField:
LOAD distinct Startdate as CalendarDate
Resident Data;
Concatenate
load distinct Enddate as CalendarDate
Resident Data;
Use the CalendatDate as Slider date.