topic Re: Checkbox functionality with a table box and date comparision in QlikView

Checkbox functionality with a table box and date comparision

Fri, 27 Jun 2014 21:44:02 GMT

Hi All,

I need your help with my requirement here.

1. I've a Start Date and End Date fields which are defaulted to the current date. User can change these dates as below.

2. I've a table box with information , for example, Student Information

3. I've a checkbox to include/exclude DOB in the search with the dates given above. Checkbox is a listbox with one value.

My requirement is: if the checkbox is checked, then table box should include Date of Birth as a filter, otherwise it should display all the students information i.e. table box should display as below

When I uncheck the checkbox, the table box should display all the data as below

Appreciate help !!

Re: Checkbox functionality with a table box and date comparision

swuehl — Sat, 28 Jun 2014 08:43:52 GMT

A table box won't allow you to set expressions or calculated dimensions to filter your data, so if you need to stick with the table box (instead of using a table chart), you can try to use a trigger on the selection of your field you are using in the check box style list box (set the trigger in Settings - Document Properties - Triggers - Field Event Trigger), then create a Select - Select in Field action on your field DOB with a search expression like

='>=' & vStartDate & '<=' vEndDate

Re: Checkbox functionality with a table box and date comparision

Sun, 29 Jun 2014 13:09:50 GMT

Thanks Swuehi.. it worked. However, when I uncheck the checkbox, I've set those variables to blank i.e. I've to remove the date filters.

set the trigger in Settings - Document Properties - Triggers - Field Event Trigger - doesn't have any options to recognize whether use is checking or unchecking.

Thanks in advance !!

Re: Checkbox functionality with a table box and date comparision

swuehl — Sun, 29 Jun 2014 13:22:12 GMT

I think you can add this logic to your search string in the select in field action:

=if( GetSelectedCount( YourFieldInListBox ) = 1 , '>=' & vStartDate & '<=' vEndDate )

Re: Checkbox functionality with a table box and date comparision

Mon, 30 Jun 2014 19:07:11 GMT

This worked.. Thanks so much Swuehl