Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
See this tutorial: Selecting Arbitrary Date Ranges
Can you please explain more. I am new to qlikview and didnot get the point
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
You can't. You'll need two multiboxes. See attached example.
This works Gysbert. Thank you. Alternate state won't cause any issue in Access point as well. Correct ?
Correct. Alternate states will work in the ajax client too.