7 Replies Latest reply: May 3, 2012 4:32 AM by Joachim Rogginer RSS

    Question about usage of num#

    Joachim Rogginer

      Perhaps a simple problem, nevertheless I diddn't succeed in solving it:


      In my database I have a string field with this format: 1234_.000 (numbers followed by an underscore and a dot and then three zeroes).
      In QlikView I want to make a numeric field out of it: 1234.

      Is this possible by ONLY using num# ? I know I could simply use num(replace(myField,'_.000','')) as my_NumField, but I thought it should actually be possible by only using num# .

      I'd be thankful for any suggestions.