Alternate states - exclude state 1 selections from state 2?

[martyn_birzys]

I'm working on customer segmentation and pricing app, and wondering can this be achieved with alternate states.

I have several tabs, each tab has its own alternate state.

I would make selections in the Tab1, let say I make multiple selections (keyword, etc) which selects 10,000 out of 100,000 Customers.

Now I proceed to Tab2, to make further selections, but I need to exclude the 10,000 customers selected in Tab1.

Tab3 would exclude Tab1 and Tab2 selections, and so forth.

Is that possible to achieve?

[sunny_talwar]

May be this:

{AlternateState2 -AlternateState1}

UPDATE: You might need to add more set analysis in there, but to get a more detailed answer, we would need to see what you have and what are you trying to get

[ajsjoshua]

HI,

{[Name of the Alternate State] <Dimension1 = [Name of the Alternate State] :: [Dimension1]> }

Ex: {B <[Year] = ::[Year]>}

Here above, I want to get the Alternate State B, except on Year where I want to apply the Alternate State A.

Regards,

Joshua.

[MK_QSL]

Something like this?

[martyn_birzys]

Yes, that's exactly it!

Could you talk me through how this was achieved?

[MK_QSL]

I have created three alternate state

S1, S2, S3

Three tab having three list box of Customer having different States

First Tab has List Box Customer with State S1

Second Tab has list box customer with State S2 but this is created using an expression..

You can see the expression there..

Second Tab has list box customer with State S3 and this is also created using an expression..

[martyn_birzys]

Can you explain the expression? What is E() doing?

=Aggr(Concat({<Customer = E({1<Customer = S1::Customer>}Customer)>-<Customer = S1::Customer>}DISTINCT Customer,'"|"'),Customer)

Values in state2 are not selected like in your test app. Any ideas why?

[MK_QSL]

P() and E() in set analysis expression

[martyn_birzys]

Ok, the solution works on one dimension, but when I have more than one it does not work.

For example I have ID, Category and Region. If I select Category A, I get 2 customer ID's. When I select Region North, I have only 1 selected customer. Now when I go to Alternate State 2, I need to see all customer IDs except Category A  Region North. But instead I don't see any more Category A at all. See my example attached.

Also, see the ID listbox in Sheet1. If there are no ID selected in Main Sheet, this listbox is empty, in your example it shows all available records and all records are automatically selected - how do you achieve this?