2 Replies Latest reply: Jun 7, 2012 11:22 AM by AJ Korbel RSS

    New to QlikCommunity - Need some help

      Hello,

       

      I'm a new user to QlikView and have been reviewing the Community for answers to my current issue:

       

      I'm have a data set that has a "*" as a prefix to the data (IE: *79-XXXXX). In order for me to correctly join this with our other item fields it needs to be stripped of the "*".

       

      My questions:

       

      1) How do I accomplish this?

      2) Where do I put this conversion in? Load script or after the data is the QVW?

       

      Thank you-

      AJ