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

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

Mon, 05 Sep 2011 13:58:16 GMT

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

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

Tue, 06 Sep 2011 10:18:01 GMT

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

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

Tue, 06 Sep 2011 14:51:56 GMT

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?

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

Thu, 27 Oct 2011 11:20:56 GMT

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