How do I group teams and not count certain ones?

[#1]

Hello,

I am working on a quick bar graph to show how many help desk tickets get sent to certain teams. I need to do two things that I'm having a bit of trouble with accomplishing.

1. Not display my own team
2. Group similar teams together

For the first part I'd like to do this without having to resort to a filter pane since there are hundreds of teams in the organizations.

For the second part we have several teams that I'd like to group together in a fashion like

IF <field name> is like DSK* or RMT* then <assign it a group name>

Any help with this would be greatly appreciated.

Thanks,

Mike

[brunobertels · Accepted solution]

Hi Mike

here different simple ways to group your team

first : by adding a table from an excel file with 2 fields team and group team. You can add several another fields if not exist in your data base as geographic ventilation:

Team      group_team     localisation

Team 1     group A          NY

Team 2     group A          NY

Team 3     group B          LA

Team 4     group B          LA

My team     -                   -

and so on

load this kind of file and ensure the team field name is the same in your different data base

second :

by adding calculated dimension in the script :

something like that

base:

LOAD

Team,

If(Team='*DSK*' OR '*RMT*',group_A,

if(Team='*ABC*' OR '*DEF*',group_B,null())) as GROUP_TEAM,

From .....

Hope it's help

Bruno

[#3]

WILDMATCH function will let you check your Team against a list, rather than a long list of ORs

http://help.qlik.com/sense/2.0/en-US/online/#../Subsystems/Hub/Content/Scripting/ConditionalFunction...

[#4]

Think this link will be more useful!

Qlik Sense - Dimension Grouping (video)

[reddy-s]

Hi Mike,

An additional field in your script which specifies a group for each entry can help solve your issue.

For example:

Member, Team

A,Team 1

B,Team 1

C,Team 1

A,Team 2

D,Team 2

E,Team 2

F,Team 2

Now if you use the team as a dimension you will be able to achieve what you are looking for.

Thanks,

Sangram

[#6]

Along with the original answer this is extremely helpful as well. Thank you

[#7]

That worked. Thanks. Also the other suggestions are going to be helpful long term so thank you everyone.