Storing Multiple Values in a Variable for Set Analysis

[#1]

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

[robert_mika · Accepted solution]

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

variable

vQuarter:

Q1,Q2

[#3]

Thanks Robert! Worked beautifully!

-Jason