Dimensions - Grouping

[Anonymous]

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

[sunny_talwar]

May be make use of Pick(Match(...)) function instead of using if statement to make your groupings

[Anonymous]

Hello Sunny,

Thanks for your replay, this expression will be ok?

=Pick(Name,'Bicycle messenger'),'Bicycle messenger',

Pick(Name,'Bill collector'),'Bill collector',

Pick(Name,'Biologist'),'Biologist',

Pick(Name,'Boilermaker'),'Boilermaker',

Pick(Name,'Bookbinder'),'Bookbinder',

'Other')))))

thanks in advance

[sunny_talwar]

For this, you can try this:

=If(Match(Name, 'Bicycle messenger', 'Bill collector', 'Biologist', 'Boilermaker', 'Bookbinder'), Name, 'Other')

[Anonymous]

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

[sunny_talwar]

Try with WildMatch

=If(WildMatch(Name, 'Bicycle messenger', 'Bill collector', 'Biologist', 'Boilermaker', 'Bookbinder'), Name, 'Other')

[Anonymous]

did not work, same result...

[sunny_talwar]

Can you share a filter object for the field Name?

[Anonymous]

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

[sunny_talwar]

Hahahaha okay, try this

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