topic Date as Slider in QlikView

Date as Slider

Mon, 29 Sep 2014 06:59:44 GMT

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

Re: Date as Slider

Mon, 29 Sep 2014 07:04:13 GMT

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

Re: Date as Slider

Mon, 29 Sep 2014 07:08:15 GMT

Please see attached qvd. MV

Re: Date as Slider

Mon, 29 Sep 2014 07:19:45 GMT

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

Re: Date as Slider

Mon, 29 Sep 2014 07:19:58 GMT

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.