Set Analysis: how to reverse the selection of specific fields?

[#1]

Hi all,

is it possible to use the {1-$} set analysis to reverse only a subset of current selections inside my document, not affecting other selections, for example specificying the selections to reverse through modifiers?

Thanks

[#2]

Anyone?

It's very important for me understand this: if it is possible with set analysis to reverse the current selections on the document only for certain fields of the current selections and for the other one's.

Thanks

with set analysis

[#3]

Usually it is possible. Either using {1-$} for all fields or element function E() to get excluded values for specific fields.

Do you have any specific expression that doesn't work as expected?

[#4]

I have a similar question.

I'm looking at 3 fields in my data:-  Age Band, Gender and Type (1-3)

I'd like to be able to select from List Boxes, for example     17-25, Male, Type 1

but the count to display all records with                             17-25, Female, Type 1           ie. Y N Y

or                                                                                   17-25, Female, Type 2&3       ie. Y N N

For various combinations of Yes and No.

I currently have: 

Num (Sum( {1-$< GENDER = {$(vGender)} >}  IsCounted),'#,##0')

which will correctly count all records with the opposite value of my gender selection, but it doesn't work if I add more than one field into the Set Analysis.

Any help with the required code structure would be a big big help.

Cheers,

Mike