Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
See attached working example
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
It's what i want!
Thank You!
You're welcome
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.
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
Thank you! Now it works!