select excluded in a straight table

[#1]

Hi all,

I have a problem.

I have a straight table with a field named Letter that has the values A,B,C,D.

Letter    Number

A             2

B             4

C             3

D             7

In my straight table I want to view excluded values when I make a selection on the field, for example I select the value A. I can use a document trigger: in the section 'field event trigger' I choose the field and I create an action 'on select' with 'select excluded'. In this way I see in my table all field values without A, for example B,C,D.

If I make another selection on my field, for example B, the trigger shows me the values A,C,D.

I don't want this result, but I want that the second selection remembers that I have excluded A previously.

I have attached a file with another example of what I want to do.

[JonnyPoole]

You can use SET ANALYSIS to do the context in a chart or text box expression (or multiple).

The following will show the non-selected values for Region in the table when a selection(s) is made on Region

[stigchel]

See attached working example

[stigchel]

Instead of selecting the excluded I update (add the new value to any already existing) a variable with every selection you make in Letter. Then in the set analysis of the expression I select all values of letter minus the contents of the variable

[#5]

It's what i want!

Thank You!

[stigchel]

You're welcome

[#7]

I have tried the solution but doesn't work. In my table number values are calculated between a fuction: for example count(Letter)

When I try your example with   =Only({<Letter={'*'}-{$(=vSel)}>} count(Number)), it doesn't work.

[stigchel · Accepted solution]

The solution is simple, instead of Only use the Count, so:

=Count({<Letter={'*'}-{$(=vSel)}>} Number)

The Set expression will work in any function that takes set analysis

[#9]

Thank you! Now it works!