1 Reply Latest reply on Jan 3, 2014 2:56 AM by Prashant Sharma

    Using dynamic list to filter/group elements

    CJ Ragnarsson

      I'm currently using some logic to split out my dates into multiple groups:

       

      if float([Date filter]) - float([order_week]) < 0 then "After"

      elseif float([Date filter]) - float([order_week]) <= 7 then "During"

      elseif float([Date filter]) - float([order_week]) <= 14 then "Pre"

      else "Before" end

       

      I would like to be able to exclude some dates dynamically, something like:

       

      if float([Date filter]) - float([order_week]) in (2,3) then "Exclude"

      elseif float([Date filter]) - float([order_week]) < 0 then "After"

      elseif float([Date filter]) - float([order_week]) <= 7 then "During"

      elseif float([Date filter]) - float([order_week]) <= 14 then "Pre"

      else "Before" end

       

      Ideally, I'd like to be able to generate the list (2,3) from a filter that the user can set.

       

      If there is only a single element, I could use a parameter, but how do I do this for multiple elements?