2 Replies Latest reply on Aug 3, 2018 8:32 AM by Jieliang He

    Set up a parameter to control a filter

    Jieliang He

      I made up a parameter and two calculated fields in order to use the parameter to turn on & off a filter:

       

      It works all right turning on the filter but not while turning off. When the FALSE is chosen, I want no filter.

       

      CASE [Parameter 1]

      WHEN TRUE THEN [Calculation1]

      WHEN FALSE THEN NULL

      END