Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Two list boxes to create a date range selection

Is there a way to use two list boxes to create a date range selection?  This would be similar to a betwen statment in a where clause.

Jim

4 Replies
swuehl
MVP
MVP

Not sure if I understood you completely, if you got a field list box of type date (like month for example), you can multiselect the month values (e.g. June to September). This should result in a date range selection for your objects.

You could also use the search to set the date range, just use the search icon of the list box or click the caption and start typing (the search string is depending of the data type).

If you explicitely want to use two kind of input fields set the date range, you could use two input boxes preset with the date field data. The selected values are assigned to variables then and you can then use the date range for limiting dates in expression etc.

Not applicable
Author

Your last option seems very interesting to me.  Is there any good documentation on paramtiters or any good examples using/setting them up?

swuehl
MVP
MVP

Please find attached a simple example on how to use two input boxes for date range selection.

Probably most problematic or new will be the use of so called set analysis, which allows to use a different selection (aka set) within the chart expression.

If you are not familiar with this up to now, it is worth looking into the set analysis page of the help or e.g. here: http://iqlik.wordpress.com/2010/08/14/the-magic-of-set-analysis-introduction/

Regards,

Stefan

P.S. Could have some not-so-complicated expression if you don't have a requirement that selection of a date won't affect your data range and vice versa, i.e. of you select a date range and the select a date from the field box, it won't matter if the new selection will override your date range selection.

edited by swuehl

swuehl
MVP
MVP

I just read a different post with similar topic:

http://community.qlik.com/thread/14324?tstart=0

which recommended this:

http://community.qlik.com/qlikviews/1075

Maybe this helps also.