Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
SomeDudeAtWork
New Contributor III

Grouping Analysts

Good morning all,

I'm currently trying to group analysts per market
So like John Smit to French, Edward Coolman to German, Peter Pan to America, and so on for about 100 analysts. I tried the if categories, but i can't seem to choose more than 20 conditions, and didnt work at all. Formula i wrote was an utter mess.

Any help regarding this would be greatly appreciated.

Labels (2)
1 Solution

Accepted Solutions
SomeDudeAtWork
New Contributor III

Re: Grouping Analysts

It's okay, i seem to have worked it with a complicated nested if.

Thank you

View solution in original post

4 Replies
MVP
MVP

Re: Grouping Analysts

In the script, you may try using  applymap()

SomeDudeAtWork
New Contributor III

Re: Grouping Analysts

must be doing something wrong but it's not working, i'd share a screen shot but the names have to remain internal as per GDPR

Edvin
Contributor

Re: Grouping Analysts

Make dummy data and show the code, otherwise it's hard to understand what you did wrong in the code.

SomeDudeAtWork
New Contributor III

Re: Grouping Analysts

It's okay, i seem to have worked it with a complicated nested if.

Thank you

View solution in original post