5 Replies Latest reply: Oct 20, 2014 1:20 PM by Jonathan Poole RSS

    QlikSense SQL Numbers and Dates not Recognized

    Tom Trinter

      I am pulling data into QlikSense from SQL Server.  The data is loading fine, but QlikSense doesn't seem to recognize the numbers as numbers.  I can get dates to format correctly by creating a new dimension and wrapping the field with Date ([Field Name]).  However I cannot get numbers to be recognized as numbers.  The SQL data is defined as decimal(15,2).  Even the data preview shows values (see attached) but graphs and any aggregation returns a zero for everything.

       

      Has anyone had this issue before and resolved it?

       

      Thanks!

      Tom