exact string search in dynamic chart

[#1]

hi all,

Please help me to resolve below issue.

I have a list box with values as below.

     ramana

     man

     ram

     gopal

I have a chart which dynamically reads the list box and shows expressions

I have written enable conditional for each dimension as below

GetSelectedCount(Dimension) > 0 and SubStringCount(Concat(Dimension,','),'gopal')>0

GetSelectedCount(Dimension) > 0 and SubStringCount(Concat(Dimension,','),'man')>0

GetSelectedCount(Dimension) > 0 and SubStringCount(Concat(Dimension,','),'ram')>0

GetSelectedCount(Dimension) > 0 and SubStringCount(Concat(Dimension,','),'ramana')>0

but when i select ramana, it is showing man, ram and ramana as 1 and 2 are subset of 3rd. But i would like to display only ramana.

how to resolve this? The selection of fields might be in any order, but it should show correct values. Plz guide me.

Thanks in advance.

[Gysbert_Wassenaar]

Try expressions like: GetSelectedCount(Dimension) > 0 and max(match(Dimension, 'man'))

[maxgro]

another one

=GetSelectedCount(Dimension) > 0 and SubStringCount('@' & Concat(Dimension,'@') & '@' ,'@ram@')>0

[#4]

You may also load some numbers or letters in additional field and then use it in condition,

for example Dimension=gopal->Dim_nbr=1; Dimension=man ->Dim_nbr=2 etc

Then use for exmple condition like this:  FindOneOf(concat(Dim_nbr),'1')

regards

Darek