Check 'Does the current selection contain XY'?

pennetzdorfer — Wed, 20 Mar 2013 17:03:00 GMT

I need to check whether the current selection contains any Austrian orders or not. Therefore I created a textbox with the following expression:

if(substringcount(Concat(distinct Country,'|'),'Austria')=1,'yes','no')

I think that's not 100% safe. Let's assume there is a Country 'AustriaXYZ' ... my expression would return 'yes' -> which is wrong!

I guess there should be a better way ... Any suggestions?

Please find the attached sample qvw.

Regards,

Florian

Re: Check 'Does the current selection contain XY'?

Gysbert_Wassenaar — Wed, 20 Mar 2013 17:10:23 GMT

You could surround the values with some marker character:

if(substringcount(Concat(distinct '~' & Country & '~' ,'|'),'~Austria~')=1,'yes','no')