Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
ezec1807
Creator
Creator

Formatted text fields Script

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

4 Replies
swuehl
MVP
MVP

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 ....;

ezec1807
Creator
Creator
Author

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!

swuehl
MVP
MVP

It will use automatic interpretation, like described here

Automatic Number Interpretation

ezec1807
Creator
Creator
Author

Thank you very much for the help!

Cheers,
Ezequiel