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.
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.
