Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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

How to select all from a field, excluding selected?

try

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

Hope this helps,

Stefan

3 Replies
afuchten
Valued Contributor

How to select all, excluding selected?

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)}

MVP
MVP

How to select all from a field, excluding selected?

try

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

Hope this helps,

Stefan

Not applicable

How to select all from a field, excluding selected?

Perfect – thanks for your help!