10 Replies Latest reply: Aug 7, 2014 8:42 AM by Evan Kurowski RSS

    Wrapping the field values at script level

    Sudeep Mahapatra

      Hi,

      I've a table with fields like below

      id     address

      1      abcdefr

      2      abcdreftt

      3      abdcsdfgtr

      4      abbqweds

      5      abbcddfgf

      6      acvbjhgfdd

       

      I would like to wrap this dynamically for each 3 chars of the field address.

      I can have a solution like below but need to do it dynamic.

       

      if(len(address)>3,left(address,3)&chr(10)&right(address,len(address)-3)) as newaddress

       

      the newaddress will have values like below

      id    newaddress

      1     abc

             defr

      2    abc

            dreftt

      3    abd

            csdfgtr

       

      but what I'm trying to achieve is like below

      id    newaddress

      1    abc

            def

            r

      2    abc

            dre

            ftt

      3    abd

            csd

            fgt

            r

       

      I'm creating alerts in QlikView. Since the alerts Subject panel does not have format options or options for embedding charts/tables so I'm trying to create a table like format for the data to be put in the Alert Subject section. Some lengthy field values are creating trouble so I'm trying to wrap them.

      Any suggestions please. Thanks in advance.