Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Not applicable
Author

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
oscar_ortiz
Partner - Specialist
Partner - Specialist

Gysbert_Wassenaar

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
Not applicable
Author

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. 

Not applicable
Author

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!