4 Replies Latest reply: Oct 10, 2012 11:39 AM by David Wood RSS

    Creating a dynamic URL with Fields values

      Hi, I am new to QlikView and am trying to find a method of displaying an image within a text object based on a URL which is dynamically constructed using field values. For example I have tried to create an expression using a field 'Serial_number'. If I construct the url as a straight string with values it display ok but a soon as I try to replace the values with the field values it does not.

       

       

      ='http://mysite.myimages.co.uk/imagestore/Titles/0' +

      left(chr(Serial_number),3) + '00/0' + chr(Serial_number

      ) + '-FC8.JPG'

       

      Any help would be much appreciated.