topic 2 controls to encapsulate a date range in QlikView

2 controls to encapsulate a date range

Tue, 16 Jun 2009 22:13:52 GMT

Hello,

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?

2 controls to encapsulate a date range

rwunderlich — Wed, 17 Jun 2009 00:21:40 GMT

There are several threads in this forum discussing this exact issue. Search the site for "date range" and you'll find a wealth of information.

Let us know if you have more questions after reading the other posts.

-Rob

2 controls to encapsulate a date range

Wed, 17 Jun 2009 02:59:20 GMT

Rob is right -- this search session I found the following thread:

http://community.qlik.com/forums/p/15653/60952.aspx#60952

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")

2 controls to encapsulate a date range

Anonymous — Wed, 17 Jun 2009 03:12:32 GMT

In this case you can use a macro that checks Date_hi > Date_lo, and does something about it - message or some deafult dates, etc..

2 controls to encapsulate a date range

rwunderlich — Wed, 17 Jun 2009 05:14:15 GMT


rsarvas wrote:However... the user can still choose a From-date far later than To-date and there's nothing you can do about it

See this thread for a couple of solutions. (Read the entire thread)

http://community.qlik.com/forums/p/16998/66939.aspx

-Rob