Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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!
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?
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.
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!