Using Buttons to Exclude Data

[#1]

I would like to be able to allow my users to push a button that would let them see only the active or in active items from a data list.  Inactive is based on the inactive date in the data.  So as of today anything in the past(1/9/2012 being the present as it is today's date) would show up with "Inactive" in the Qlikview and anything 1/9/2012 and into the future would be active.  Unfortuantely, the blanket order data does not have and field that changes items from active to inactive so I had to use the date field they have set up.

Any suggestion on how to do this would be greatly appreciated.

Thank you

[pover]

You can either filter the date field directly or create a bookmark that selects or filters out the inactive dates.  The seach string would be something like the following:

=OrderDate>=today()

A third option would be to make a button that trigger an action that filters the date field.  I've attached an example of the third option.

Karl