topic Re: Formatted text fields Script in QlikView

Formatted text fields Script

ezec1807 — Wed, 13 Jan 2016 19:05:31 GMT

Good .
I am running in one query raising Script fields that come with varchar format ( alphanumeric ) from a database of SQL Server. It is a field with a value eg . " 000245 " and is associated with the name " Maria " field and a value " 245 " into the field "John" . What makes me qlikview two values is Mary and John with the value 245 , instead of showing " 000245 " to Mary and " 245 " for John.
Someone can help me?

Thank you!

Cheers,
Ezequiel

Re: Formatted text fields Script

swuehl — Wed, 13 Jan 2016 19:44:12 GMT

You'll need to force QV to look at 000245 and 245 as distinct text values instead of numbers, i.e. using

LOAD

Text( YourField ) as YourField,

...;

SELECT YourField, ... FROM ....;

Re: Formatted text fields Script

ezec1807 — Wed, 13 Jan 2016 20:07:21 GMT

Hi.
That works. But qlikview can not import the field as text ( as it is in the SQL database server) ?
Not configurable this, in the tool ?

Thank you!

Re: Formatted text fields Script

swuehl — Wed, 13 Jan 2016 21:46:32 GMT

It will use automatic interpretation, like described here

Automatic Number Interpretation

Re: Formatted text fields Script

ezec1807 — Thu, 14 Jan 2016 19:16:49 GMT

Thank you very much for the help!

Cheers,
Ezequiel