Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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 ....;
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!
It will use automatic interpretation, like described here
Thank you very much for the help!
Cheers,
Ezequiel