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: 
SomeDudeAtWork
Contributor III
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
Contributor III
Contributor III
Author

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

Thank you

View solution in original post

4 Replies
tresesco
MVP
MVP

In the script, you may try using  applymap()

SomeDudeAtWork
Contributor III
Contributor III
Author

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

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

SomeDudeAtWork
Contributor III
Contributor III
Author

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

Thank you