Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.


Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

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.

2 Replies
Not applicable

Re: how convert number field to text

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?

talk is cheap, supply exceeds demand
Not applicable

Re: how convert number field to text

That's sound right as above, text() is the one to use.

If it is alpha-numeric, how are non-numeric characters displayed? Could you post screenshot?

Experiment with string operations to assure it comes across as string, eg:

'A' & Invoice_Num as Invoice_Num_Test