12 Replies Latest reply: May 16, 2018 4:01 PM by Miguel Rijk RSS

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

    Miguel Rijk

      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";