Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

urielted
New Contributor II

Re: Dimensions - Grouping

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

Re: Dimensions - Grouping

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

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

urielted
New Contributor II

Re: Dimensions - Grouping

=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')

Highlighted

Re: Dimensions - Grouping

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

=Pick(WildMatch(Name,

'*Dad*',

'*Daddy*',

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

'Dad',

'Daddy*',

'Father')

urielted
New Contributor II

Re: Dimensions - Grouping

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

Re: Dimensions - Grouping

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?

urielted
New Contributor II

Re: Dimensions - Grouping

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

Re: Dimensions - Grouping

Community Browser