Check 'Does the current selection contain XY'?

[pennetzdorfer]

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

[Gysbert_Wassenaar · Accepted solution]

You could surround the values with some marker character:

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