4 Replies Latest reply: Oct 31, 2016 8:54 AM by Mike Lutomski RSS

    Creating a list from Variables in Set Analysis

    Mike Lutomski

      I am trying to use multiple variables to limit a single dimension in Set Analysis for a master measure.

       

      I am using the below script in a Chart with "Business Unit" & "Quarter-Year" as a dimension, and it's not working.

       

      Quarter-Year = {$(Variable_1),$(Variable_2),$(Variable_3)}

       

      Since "Quarter-Year" is a text field, I can't use a range such as {">=$(=$(Variable_1))<=$(=$(Variable_3))"}, either.

       

      Would this work better as an OR, or is there another way to write this?

       

      Should I create new fields in the Data Model to replace the Variables?

       

      I initially tried using the following, but it breaks my Color By Expression for the Business Units:

       

      [Summary Date]={'>=$(=date(QuarterStart(AddMonths(Max([Summary Date]),-11))))<=$(=Max([Summary Date]))'}

       

      Here is my Color By Expression script:

       

      RGB(Subfield([Summary_BUColor],',',1), Subfield([Summary_BUColor],',',2), Subfield([Summary_BUColor],',',3))

       

      Suggestions to make any of the above work would be appreciated.

       

      Thanks.

       

      -Mike