topic Re: Field Alphanumeric in QlikView

Field Alphanumeric

Thu, 26 Jul 2012 14:38:57 GMT

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.

Re: Field Alphanumeric

CELAMBARASAN — Thu, 26 Jul 2012 14:51:20 GMT

Use Text(FieldName) which converts it as string

Re: Field Alphanumeric

Thu, 26 Jul 2012 15:45:13 GMT

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.

Re: Field Alphanumeric

Thu, 26 Jul 2012 17:49:53 GMT

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.

Re: Field Alphanumeric

Thu, 26 Jul 2012 18:05:54 GMT

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)

Re: Field Alphanumeric

Thu, 26 Jul 2012 18:41:12 GMT

Ok, thanks for your help.