How to select a range of dates from list box

[#1]

Hi,

I have list box DATE. The dates are from 2006 to 2013. My user wnats to select the dates from 01/01/2007 to 31/12/2007 all at once by clicking CTRL+selections in list box with out dragging.

Is there any possibility in qlikview to get dates using BETWEEN and AND

for eg: date BETWEEN 01/01/2007 and 20/05/2007

please could anyone help me in this.

Thanks.

[#2]

How can I use slider?please tell me

[MK_QSL]

RIght Click

New Sheet Object

Slide/Calender Object

Input Style = Slider

Field = Your Date Field

Mode = Multi Value

Presentation - Scale need to change according to your need

But here also, user have to use slider from one date to another and it is not convenient if you have many dates as it is impossible to show all dates and also will consume more space in your sheet.

[MK_QSL]

Hi Rob,

Can you explain how the check constraint is appearing...

[MK_QSL]

got it.... !!! thanks for this example...

[stevelord]

If you want between two dates, you can do it with one variable if one date is a fixed increment from the other.  If the number of days can vary, the two variable approach is needed.

One of our tasks involves weekly challenges and the increment is always 7 days for those.  So we'd use something like:

Count(Distinct if(Date>=vDate AND Date<vDate+7, UserID, 0))

Also a nice ham-fisted approach to selecting all dates there are is to make another field in script year(Date) as Year, setup a listbox for that, and click on the couple of years.  Or some concats of year(Date)&' '&month(Date) as YearMonth in a listbox to handle date ranges that go from part of one year to part of the next.  (I have people pushing back on having to type anything, and pushing back on having to click on more than two things... )

[Anonymous]

Just press enter [return] and it will be selected