topic Re: Date Range Selection using multibox in QlikView

Date Range Selection using multibox

Thu, 23 Apr 2015 09:30:41 GMT

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.

Re: Date Range Selection using multibox

datanibbler — Thu, 23 Apr 2015 10:04:14 GMT

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.

Re: Date Range Selection using multibox

Gysbert_Wassenaar — Thu, 23 Apr 2015 10:11:17 GMT

See this tutorial: Selecting Arbitrary Date Ranges

Re: Date Range Selection using multibox

Thu, 23 Apr 2015 10:12:37 GMT

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

Re: Date Range Selection using multibox

Thu, 23 Apr 2015 10:16:22 GMT

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

Re: Date Range Selection using multibox

Gysbert_Wassenaar — Thu, 23 Apr 2015 10:25:48 GMT

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

Re: Date Range Selection using multibox

Thu, 23 Apr 2015 11:42:01 GMT

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

Re: Date Range Selection using multibox

Gysbert_Wassenaar — Thu, 23 Apr 2015 11:43:43 GMT

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