Discussion board where members can get started with Qlik Sense.
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.
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.
Go to Solution.
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
by adding calculated dimension in the script :
something like that
If(Team='*DSK*' OR '*RMT*',group_A,
if(Team='*ABC*' OR '*DEF*',group_B,null())) as GROUP_TEAM,
Hope it's help
WILDMATCH function will let you check your Team against a list, rather than a long list of ORs
Think this link will be more useful!
Qlik Sense - Dimension Grouping (video)
An additional field in your script which specifies a group for each entry can help solve your issue.
Now if you use the team as a dimension you will be able to achieve what you are looking for.
Along with the original answer this is extremely helpful as well. Thank you
That worked. Thanks. Also the other suggestions are going to be helpful long term so thank you everyone.