1 Reply Latest reply: Jan 9, 2012 7:32 PM by Karl Pover RSS

    Using Buttons to Exclude Data

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