topic Re: set analysis expression on alternate states in QlikView

set analysis expression on alternate states

Tue, 15 Apr 2014 10:49:02 GMT

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??

Tue, 15 Apr 2014 10:51:59 GMT

Hi,

Try this:

Exp1:

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

Exp2:

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

MK_QSL — Tue, 15 Apr 2014 10:52:31 GMT

Something like below

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

tresB — Tue, 15 Apr 2014 11:05:09 GMT

rustyfishbones — Tue, 15 Apr 2014 11:06:35 GMT

Try this

arjunkrishnan — Tue, 15 Apr 2014 11:19:12 GMT

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