12 Replies Latest reply: Mar 16, 2017 1:31 PM by Sunny Talwar RSS

    Data converted to scientific notation

    Cliff Clayman

      I have a field that is a text field in my SQL table.  I went to great lengths to ensure this field gets assigned as text in the database.  When I add it to my Qlikview report, some of the values are still showing as scientific notation.  I load many other fields into the report and I just do a SELECT * FROM TableName.  How can I LOAD the field as TEXT in the script and just call out the field(s) I want to make as text?