Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

27 Replies
Anonymous
Not applicable
Author

because the word "art" is also in the word "smart" it show the name field with word smart in art group

sunny_talwar

May be use MapSubString with ApplyMap in the script to do this

Load script find value from one table as substring | Qlik Community

Anonymous
Not applicable
Author

=Pick(WildMatch limited to 200 record , i have over 800 record, when i insert over 200 record it give me an error any advice how to use grouping with expression that can hold over 800 record

expression i use:

=Pick(WildMatch(Name,

'*Dad*',

'*Daddy*',

'*Father*',+ 1, 'Other',

'Dad',

'Daddy*',

'Father')

sunny_talwar

This doesn't look right to me... it should be this

=Pick(WildMatch(Name,

'*Dad*',

'*Daddy*',

'*Father*') + 1, 'Other',

'Dad',

'Daddy*',

'Father')

Anonymous
Not applicable
Author

still show error if i insert over 200 record, (200 record 400 line)

sunny_talwar

I have not heard of a limit, but I have not also tested with such a long Pick(Match()) statement... have you considered using Mapping load with ApplyMap in the script?

Anonymous
Not applicable
Author

i did not try the Mapping load, that will be great if you can direct me how to do it