set analysis expression on alternate states

[#1]

I have alternate states say state1, state2.

I need to write a set analysis expression for restrict value of field Year to 2013 in State1.

How can I achieve it through set analysis??

[#2]

Hi,

Try this:

Exp1:

=Sum({state1 <Year = {'2013'}>}Sales)

Exp2:

=Sum({state2 <Year = {'2013'}>}Sales)

[MK_QSL]

Something like below

=sum({[State 1]}{<Year -= {'2013'}>}Sales)

[tresesco]

Have a look here: Is possible to use alternate States with set an... | Qlik Community

[rustyfishbones]

Try this

[arjunkrishnan]

Hai Frd,

I just Try This One ...I hope U For Helping to u

Year-S1:

SUM({S1}Sale)

Year-S2(To Restrict The Year 2013 )

SUM({S1}{<Year-={'2013'}>}Sale)

My Result Like That

Thank You

ArjunKrishnan