1 Reply Latest reply: Mar 20, 2013 1:10 PM by Gysbert Wassenaar RSS

    Check 'Does the current selection contain XY'?

    Florian 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

       

      1.jpg