Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You could surround the values with some marker character:
if(substringcount(Concat(distinct '~' & Country & '~' ,'|'),'~Austria~')=1,'yes','no')
You could surround the values with some marker character:
if(substringcount(Concat(distinct '~' & Country & '~' ,'|'),'~Austria~')=1,'yes','no')