Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to select all from a field, excluding selected?

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.

1 Solution

Accepted Solutions
swuehl
MVP
MVP

try

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

Hope this helps,

Stefan

View solution in original post

3 Replies
Anonymous
Not applicable
Author

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
MVP
MVP

try

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

Hope this helps,

Stefan

Not applicable
Author

Perfect – thanks for your help!