12 Replies Latest reply: May 16, 2018 4:01 PM by M Richman RSS

    How to use Qlik num() or num#() function, in SQL Select properly?

    M Richman

      Hi Community,

       

      I have been trying to use number format one of my data field, however I'm getting an error on this the whole time. Would be nice if you could help, thanks in advance!

       

      Error:

       

      SQL##f - SqlState: 37000, ErrorCode: 4294964196, ErrorMsg: [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'Num(["Data"],'############')'.

       

      Script Example:

       

      SQL SELECT

          Num(["Data"],'############') as Data1,

          Data2

      FROM "MasterData";