7 Replies Latest reply: Jan 18, 2017 6:43 AM by Rene Zapf RSS

    Show values where the first 3 characters are Numbers?

    Rene Zapf

      Hello Qlik Community,

       

      as stated in the title i am trying to get only the values where the first 3 characters are numbers.
      What i know already is that i can use
      IsNum(Left(FieldName,3)) to check if the statement is true.

       

      I already tried this, but something in my function is wrong.
      sum( {$<IsNum(Left(Fieldname1,3)) = 0>} Fieldname2)

       

      Note: I am using this this expression for a chart if that is any valuable information.

       

      greetings,
      rene