Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Facing issue with Alternate states and Set Analysis

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),'#.# %')

4 Replies
sunny_talwar

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),'#.# %')

Anonymous
Not applicable
Author

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])

sunny_talwar

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),'#.# %')

Anonymous
Not applicable
Author

Thanks it works