Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try expressions like: GetSelectedCount(Dimension) > 0 and max(match(Dimension, 'man'))
another one
=GetSelectedCount(Dimension) > 0 and SubStringCount('@' & Concat(Dimension,'@') & '@' ,'@ram@')>0
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