Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
If you are a Qlik Insight Bot user, join this collaborative group: JOIN GROUP
Not applicable

Set Analysis to ignore selections in Alternate State

I have a chart using Alternate States to show comparison between 2 time period selections.  There are some other filters available in each state besides time selections, but i want to ignore any selections made on those fields in certain charts.  I have this as my expression (adapted from what i've learned in other threads here), but it doesn't seem to have any effect.  The charts are still being affected by selections on those fields (gender and Residency).  Does anyone know what I'm missing?

sum({[Period 1] <gender=, Residency=>} revenue)

1 Solution

Accepted Solutions
Highlighted
Not applicable

Re: Set Analysis to ignore selections in Alternate State

OK, i started to create a sample doc and it worked fine in there, so I went back to the doc where i'm having the trouble and figured out that the issue was happening because i had the Alternate State of the chart itself set to the respective Alternate State instead of 'Inherited' on the General tab.  When i changed it to 'inherited' the expression works as expected, ignoring the fields I indicated.  Thanks for your help!

View solution in original post

4 Replies
Highlighted
Partner
Partner

Re: Set Analysis to ignore selections in Alternate State

Highlighted
MVP & Luminary
MVP & Luminary

Re: Set Analysis to ignore selections in Alternate State

Your description offers no clues to me. The syntax is correct. A chart with that expression should be affected only by selections made in the alternate state Period 1 and disregard selections in that state in the fields gender and Residency (assuming you're using the correct case sensitive field names). Can you post a .qvw document that demonstrates the problem?


talk is cheap, supply exceeds demand
Highlighted
Not applicable

Re: Set Analysis to ignore selections in Alternate State

Thanks Oscar.  That's one of the threads that helped me get as far as I am currently, but it only shows how to assign the selections of certain fields in the Set Analysis.  I want to make it ignore selections in those fields and that doesn't seem to be working. 

Highlighted
Not applicable

Re: Set Analysis to ignore selections in Alternate State

OK, i started to create a sample doc and it worked fine in there, so I went back to the doc where i'm having the trouble and figured out that the issue was happening because i had the Alternate State of the chart itself set to the respective Alternate State instead of 'Inherited' on the General tab.  When i changed it to 'inherited' the expression works as expected, ignoring the fields I indicated.  Thanks for your help!

View solution in original post