Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

urielted
New Contributor II

Re: Dimensions - Grouping

error in expression

Re: Dimensions - Grouping

Missed a comma... try now

Pick(WildMatch(Name, '*Bicycle messenger*', '*Bill collector*', '*Biologist*', '*Boilermaker*', '*Bookbinder*') + 1, 'Other', 'Bicycle messenger', 'Bill collector', 'Biologist', 'Boilermaker', 'Bookbinder')

urielted
New Contributor II

Re: Dimensions - Grouping

U D Best!!! Working Fine!

Re: Dimensions - Grouping

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

Best,

Sunny

urielted
New Contributor II

Re: Dimensions - Grouping

Sunny Thanks so much for your professional help and fast result

urielted
New Contributor II

Re: Dimensions - Grouping

the expression also have limit to 200 record

Highlighted

Re: Dimensions - Grouping

Not sure I understand

urielted
New Contributor II

Re: Dimensions - Grouping

we try to wildmatch before, when i try to insert over 200 record in expression i get error for limit

urielted
New Contributor II

Re: Dimensions - Grouping

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

Re: Dimensions - Grouping

You are not very clear... would you be able to share a sample where we can see the issues that you are mentioning above?

Community Browser