topic Input Box Date Range in QlikView

Input Box Date Range

james — Fri, 26 Jun 2009 23:21:18 GMT

All - Dos anyone have any solid working solution that will select a date range based on a user input into a "Input Box"?

Many users are technically challneged and having an easy box for start and end would help, the slider seems to complicated

Input Box Date Range

Anonymous — Sat, 27 Jun 2009 00:12:11 GMT

James,
I'm not sure what is your definition of a "solid working solution"... The attached example is showing how to select a date range based on a user input into a "Input Box". Actually, two "calendar objects" instead of the input boxes. If you wish, you can use input boxes here.
(My own definition of a "solid working solution" - use selections in the fields (year, month, date). No input boxes, no macros.)

Input Box Date Range

james — Sat, 27 Jun 2009 00:22:38 GMT

Michael, I completely agree, the best solution is to click. Some users just cnanot grasp it, I dont know why, they just cant..

Input Box Date Range

rwunderlich — Sat, 27 Jun 2009 00:44:56 GMT

If you use input boxes instead of Calendar objects, you'll have to do some validation. Here's an example using input boxes that validates for:

- Correct date format
- Date with possible range
- Start < End

-Rob

Input Box Date Range

james — Fri, 10 Jul 2009 01:15:12 GMT

Rob, I cant seem to change this to use MonthYear..any idas

Input Box Date Range

rwunderlich — Mon, 13 Jul 2009 23:47:13 GMT

What part(s) are you having trouble with, validating the input or making the selection?

Can you upload your sample?

-Rob

Input Box Date Range

Tue, 12 Jan 2010 17:10:09 GMT

Rob,

Using your Example Posted Here, If you select Jan as a month shouldnt all the Dates in JAN Go green Instead of White (available to be selected from) or am i understanding this wrong

Colin

Input Box Date Range

rwunderlich — Wed, 13 Jan 2010 21:09:27 GMT

Add the dateChange as an OnChange event to correct this.

-Rob