topic Re: exact string search in dynamic chart in QlikView

exact string search in dynamic chart

Fri, 09 May 2014 16:58:10 GMT

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 — Fri, 09 May 2014 17:13:42 GMT

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

maxgro — Fri, 09 May 2014 17:38:50 GMT

another one

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

Fri, 09 May 2014 21:15:08 GMT

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