Field Alphanumeric

[#1]

I have a problem in QlikView in connection with submission of an alphanumeric key field. The client wants the number to appear as the database.
Example: COD_CLI = 01855 and 0001855 (SQL Server).

For QlikView, this is only one number: 01855. Has anyone experienced a similar situation?

Thanks.

Marcia.

[CELAMBARASAN]

Use Text(FieldName) which converts it as string

[#3]

You will need to wrap COD_CLI as text(COD_CLI) in the script itself so that QV interprets it as a string and retains both variants 01855 and 0001855.

[#4]

I had already done that when I run the command Load, but it did not work.
I also put the function Text (COD_CLI) in the expression, but neither worked. What I am trying to do now is to concatenate a string 'x' and then, using the function Text (Mid (COD_CLI, 2.8)) to take it on screen.
It seems to be working, but when I put the field in the list, concatenated field is presented.

Thank you,
Marcia.

[#5]

I'm hoping you mentioned Text(COD_CLI) as [COD CLI] in the load script because the load will fail if you just wrote Text(COD_CLI)

[#6]

Ok, thanks for your help.