2 Replies Latest reply: Oct 1, 2014 10:02 AM by Martyn Birzys RSS

    how convert number field to text

      The invoice_num field in Oracle Financials is text (the data is alpha/numeric) but when the field is in Qlikview it is showing it as a number. I have put in script TEXT(Invoice_Num) but this has made no difference, any ideas how to get it as text? The field is in a table that is extracted into a QVW and this is reloaded once a day. The QVW just says the table name and all fields are extracted for the table.