Date Range Selection using multibox

[#1]

Hi,

For one of the requirement , I need to use 2 multibox which user will use to select a date range.

I have a date Column as Approval Date. Now I want user to select any date range using From Date - To Date (using the two multibox)

and  data should filter for specified date range.

Any idea how can I start with this.

[datanibbler]

Hi Vineeta,

using the two fields "from_date" and "to_date", just create two triggers (in the document_properties, on field_level, upon selection in those two fields) to make a selection of "> from_date" and "< to_date" respectively on your single date_field.

HTH

P.S.: The exact syntax for advanced selections like this is >> = [date] > from_date <<

Try it out in a textbox or listbox first to check whether the date_formats are comparable.

[Gysbert_Wassenaar]

See this tutorial: Selecting Arbitrary Date Ranges

[#4]

Can you please explain more. I am new to qlikview and didnot get the point

[#5]

Hi Gysbert

I looked the tutorial. Earlier I was using the calender object. But User came back asking to use a multibox. Any idea how can I achieve the same using Multibox

[Gysbert_Wassenaar]

You can't. You'll need two multiboxes. See attached example.

[#7]

This works Gysbert. Thank you. Alternate state won't cause any issue in Access point as well. Correct ?

[Gysbert_Wassenaar]

Correct. Alternate states will work in the ajax client too.