topic how convert number field to text in QlikView https://community.qlik.com/t5/QlikView/how-convert-number-field-to-text/m-p/735899#M670175 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Wed, 01 Oct 2014 11:44:12 GMT 2014-10-01T11:44:12Z how convert number field to text https://community.qlik.com/t5/QlikView/how-convert-number-field-to-text/m-p/735899#M670175 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Wed, 01 Oct 2014 11:44:12 GMT https://community.qlik.com/t5/QlikView/how-convert-number-field-to-text/m-p/735899#M670175 2014-10-01T11:44:12Z Re: how convert number field to text https://community.qlik.com/t5/QlikView/how-convert-number-field-to-text/m-p/735900#M670176 <HTML><HEAD></HEAD><BODY><P>Using the text function is the way to make text from numbers. Are you sure Qlikview makes numbers from them? Can you post a document that demonstrates the problem?</P></BODY></HTML> Wed, 01 Oct 2014 12:44:20 GMT https://community.qlik.com/t5/QlikView/how-convert-number-field-to-text/m-p/735900#M670176 Gysbert_Wassenaar 2014-10-01T12:44:20Z Re: how convert number field to text https://community.qlik.com/t5/QlikView/how-convert-number-field-to-text/m-p/735901#M670177 <HTML><HEAD></HEAD><BODY><P>That's sound right as above, text() is the one to use.</P><P>If it is alpha-numeric, how are non-numeric characters displayed? Could you post screenshot?</P><P>Experiment with string operations to assure it comes across as string, eg:</P><P>'A' &amp; Invoice_Num as Invoice_Num_Test</P></BODY></HTML> Wed, 01 Oct 2014 13:57:11 GMT https://community.qlik.com/t5/QlikView/how-convert-number-field-to-text/m-p/735901#M670177 martyn_birzys 2014-10-01T13:57:11Z