topic How to select all from a field, excluding selected? in QlikView

How to select all from a field, excluding selected?

Mon, 07 Nov 2011 15:49:45 GMT

Hi all.

I have a dashboard that shows activity for team members.

A person can belong to more than one team.

Activity is displayed for one team only (the team list box has Always One Selected Value checked).

I need to list the other teams that a user belongs to in a text box, excluding the currently selected team.

Example:

Bob has activity for TeamA and TeamB.

User selects Bob and TeamA.

Bob’s TeamA activity is displayed.

I now need to alert the User to the fact that Bob also has activity for TeamB.

The following lists all teams that Bob belongs to (including TeamA):

Dimension: Team

Expression: =count({<Team=>}Activity)

How can I exclude the current Team selection (TeamA) from the above expression?

Thanks in advance, Michael.

Anonymous — Mon, 07 Nov 2011 15:53:33 GMT

If it is only possible to select only 1 team value at the time you could use GetFieldSelections ...

And when using in a set analysis:

Team -= {$(variable)}

swuehl — Mon, 07 Nov 2011 15:58:39 GMT

try

count( {<Team= e(Team) >} Activity)

Hope this helps,

Stefan

Tue, 08 Nov 2011 10:41:08 GMT

Perfect – thanks for your help!