Discussion board where members can get started with Qlik Sense.
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
Go to Solution.
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
May be make use of Pick(Match(...)) function instead of using if statement to make your groupings
Thanks for your replay, this expression will be ok?
=Pick(Name,'Bicycle messenger'),'Bicycle messenger',
Pick(Name,'Bill collector'),'Bill collector',
thanks in advance
For this, you can try this:
=If(Match(Name, 'Bicycle messenger', 'Bill collector', 'Biologist', 'Boilermaker', 'Bookbinder'), Name, 'Other')
I try the expression it's not working. it only present the "other" and it group all records to "other" , it did not group the other records
Try with WildMatch
=If(WildMatch(Name, 'Bicycle messenger', 'Bill collector', 'Biologist', 'Boilermaker', 'Bookbinder'), Name, 'Other')
did not work, same result...
Can you share a filter object for the field Name?
what you mean by filter object? field name contain text for example :
"i'm the best Bill collector in the world"
"greatest Biologist in USA"
hoop that will help
Hahahaha okay, try this
Pick(WildMatch(Name, '*Bicycle messenger*', '*Bill collector*', '*Biologist*', '*Boilermaker*', '*Bookbinder*') + 1, 'Other' 'Bicycle messenger', 'Bill collector', 'Biologist', 'Boilermaker', 'Bookbinder')