Discussion board where members can get started with Qlik Sense.
error in expression
Missed a comma... try now
Pick(WildMatch(Name, '*Bicycle messenger*', '*Bill collector*', '*Biologist*', '*Boilermaker*', '*Bookbinder*') + 1, 'Other', 'Bicycle messenger', 'Bill collector', 'Biologist', 'Boilermaker', 'Bookbinder')
U D Best!!! Working Fine!
Great, I am glad it worked... please close this thread by marking correct and helpful responses (if any)
Qlik Community Tip: Marking Replies as Correct or Helpful
Sunny Thanks so much for your professional help and fast result
the expression also have limit to 200 record
Not sure I understand
we try to wildmatch before, when i try to insert over 200 record in expression i get error for limit
i also realize that result is not 100% ,for example: if one of the group in expression is "Art" and if "Name" field have the word "Smart" iy group it in "art " it is away to minimize that
You are not very clear... would you be able to share a sample where we can see the issues that you are mentioning above?