We know that with the calendar date-picker, we can select a date, or a range of dates, or even multiple ranges of dates. With the slider control, we can also select a range of dates as well.
We have an enduser who doesn't like the fiddly-ness of those two controls. They think working with those controls is too clunky and possibly confusing to some other endusers. They want to have a pair of controls to denote a "From-date" and a "To-date"; once set, the associativeness inherently knows that all dates must be concurrently >= the From-date and <= the To-date.
?So how do I get QlikView to realize this control set -- how exactly does the slider filter the date data?
using two date-pickers, and setting these variables in my QV script:
Let Date_hi = '2009-01-09'; Let Date_lo = '2009-01-05';
I was then able to make it work with setting bounds on the pickers to
=min(date_requested_on), =max(date_requested_on)
and then replacing the dimension with this construct:
=if(date_requested_on < Date_lo or date_requested_on > Date_hi, null(), date(date_requested_on))
and it works and is very cool.
However... the user can still choose a From-date far later than To-date and there's nothing you can do about it, unlike VB.NET (altho' it does give the expected snickering response "No data to display")
