topic Storing Multiple Values in a Variable for Set Analysis in QlikView

Storing Multiple Values in a Variable for Set Analysis

Thu, 20 Oct 2016 22:00:55 GMT

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

Re: Storing Multiple Values in a Variable for Set Analysis

robert_mika — Thu, 20 Oct 2016 22:39:35 GMT

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

variable

vQuarter:

Q1,Q2

Re: Storing Multiple Values in a Variable for Set Analysis

Thu, 20 Oct 2016 22:54:05 GMT

Thanks Robert! Worked beautifully!

-Jason