Using Buttons to Exclude Data

Mon, 09 Jan 2012 21:42:12 GMT

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

Re: Using Buttons to Exclude Data

pover — Tue, 10 Jan 2012 00:32:03 GMT

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

topic Re: Using Buttons to Exclude Data in QlikView

Using Buttons to Exclude Data

Re: Using Buttons to Exclude Data