Using searchable expressions with alternate states

[#1]

Hi,

I have a straight table set up in an alternate state, and in this table I have multiple expressions that I want to be able to search on. So i've enabled the "Searchable" option for the expressions under the Presentation tab, however it isn't working as expected.

Whenever I search for something in an expression a green dot appears on the dimension fields, indicating that a filter has been applied, but there is no reduction in the records that are being displayed. When I try this on a table that does not have an alternate state applied to it, it works fine.

Is there anything I need to do with the settings of the table or in the expressions themselves to make this option work with the alternate state?

[sunny_talwar]

Almost right

Intersection between every selection in Alternate State (including Person) with Person selection in Inherited state (This is assuming that the chart is in Alternate State)

[kkkumar82]

Thanks Sunny for taking out some time in your busy schedule

[sunny_talwar]

Why is everyone trying to pull my leg today .

Oh well, its that kind of a Monday

[#5]

I've looked into it and made changes similar to what you put here. The whole table was set to an alternate state so what i've done is to put this back into the inherited state and change the expression so only that is looking at the different state.

Now that i've made that change the filtering on the expressions is working, as is the filtering on standard list boxes