topic Re: Facing issue with Alternate states and Set Analysis in QlikView

Facing issue with Alternate states and Set Analysis

Anonymous — Mon, 07 Sep 2015 08:37:01 GMT

Hi the set analysis expression is working fine with the default state but it’s giving unexpected results with Alternate states

I have Alternate State of “Group1”how to incorporate the Alternate state to the below expression. Thanks

=Num((sum({1<[ Year]=P({$}[Year]),Product={'Shippers'}>}[Gross Sale])/
sum({1<[ Year]=P({$}[Year]), Product={ Shippers'}>}[Gross Revenue])-1),'#.# %')

Re: Facing issue with Alternate states and Set Analysis

sunny_talwar — Mon, 07 Sep 2015 08:44:43 GMT

You want this expression to be driven just by the alternate state only? Try this:

=Num((sum({[Group1]<[ Year]=P({[Group1]}[Year]),Product={'Shippers'}>}[Gross Sale])/
sum({[Group1]<[ Year]=P({[Group1]}[Year]), Product={ Shippers'}>}[Gross Revenue])-1),'#.# %')

Re: Facing issue with Alternate states and Set Analysis

Anonymous — Mon, 07 Sep 2015 08:50:05 GMT

Thanks for Quick Response.I'm expecting the :"1" to take the set as complete selections not current selections.

Num((sum({

1

<[ Year]=P({$}[Year])

Re: Facing issue with Alternate states and Set Analysis

sunny_talwar — Mon, 07 Sep 2015 08:53:03 GMT

May be this:

=Num((sum({1<[ Year]=P({[Group1]}[Year]),Product={'Shippers'}>}[Gross Sale])/
sum({1<[ Year]=P({[Group1]}[Year]), Product={ Shippers'}>}[Gross Revenue])-1),'#.# %')

Re: Facing issue with Alternate states and Set Analysis

Anonymous — Mon, 07 Sep 2015 11:02:27 GMT

Thanks it works