2 Replies Latest reply: Oct 20, 2016 6:54 PM by Jason Liau RSS

    Storing Multiple Values in a Variable for Set Analysis

    Jason Liau

      Hi,

       

      I have a couple of buttons that has an action to set a variable, vQuarter, to either Q1, Q2, Q3, or Q4 that works perfect. However, I want a button that can set the quarter to a combination of Q1 and Q2. Is this possible?

       

      Default in load script:

      LET vQuarter='*'

       

      In my expression I am using:

      sum($*{<[Quarter]={"$(=vQuarter)"}>} [Responses])

       

      I tried putting various methods with no success:

      ("Q1"|"Q2")

      Q1,Q2

      etc..

       

      Thanks in advance!

       

      -Jason