Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Date as Slider

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

4 Replies
Not applicable
Author

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

Not applicable
Author

Please see attached qvd. MV

Not applicable
Author

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

Not applicable
Author

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.