Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i follow the video tutorial for Dimensions - Grouping: http://help.qlik.com/en-US/sense/September2017/Content/Videos/Videos-dimensions-grouping.htm
all go ok until i insert over 100 then i get an error "error in expression too complex more 100 level nesting", i have over 750 groups any idea how to accomplish that
thanks in advance
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
Best,
Sunny
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?