Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
because the word "art" is also in the word "smart" it show the name field with word smart in art group
May be use MapSubString with ApplyMap in the script to do this
Load script find value from one table as substring | Qlik Community
=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')
This doesn't look right to me... it should be this
=Pick(WildMatch(Name,
'*Dad*',
'*Daddy*',
'*Father*') + 1, 'Other',
'Dad',
'Daddy*',
'Father')
still show error if i insert over 200 record, (200 record 400 line)
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?
i did not try the Mapping load, that will be great if you can direct me how to do it