Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

urielted
New Contributor II

Dimensions - Grouping

i follow the video tutorial for Dimensions - Groupinghttp://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

1 Solution

Accepted Solutions

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

27 Replies

Re: Dimensions - Grouping

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

urielted
New Contributor II

Re: Dimensions - Grouping

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

Re: Dimensions - Grouping

For this, you can try this:

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

urielted
New Contributor II

Re: Dimensions - Grouping

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

Re: Dimensions - Grouping

Try with WildMatch

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

urielted
New Contributor II

Re: Dimensions - Grouping

did not work, same result...

Re: Dimensions - Grouping

Can you share a filter object for the field Name?

urielted
New Contributor II

Re: Dimensions - Grouping

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

Re: Dimensions - Grouping

Hahahaha okay, try this

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

Community Browser