topic Load Text(Upper(S)) ? in QlikView

Load Text(Upper(S)) ?

johanlind — Wed, 15 Jun 2011 13:13:25 GMT

I'm reading from a SQL database, one field are alfanumeric. I want to convert it to text and upper, should I write:

Load Text(Upper(S)) as Title or Load Upper(Text(S)) as Title ?

Load Text(Upper(S)) ?

Anonymous — Wed, 15 Jun 2011 13:19:53 GMT

I think both will work fine, but I would prefer Text(Upper(S)),

Why not try both and see what the results are?

Load Text(Upper(S)) ?

Wed, 15 Jun 2011 13:22:37 GMT

I tried that :

LOAD upper(alpha) as alpha INLINE [

alpha

a34

];

and I obtain A34,B,54.

Is that what you wanted to do?

Load Text(Upper(S)) ?

Wed, 15 Jun 2011 13:31:12 GMT

Most SQL databases will allow you to convert strings to uppercase within the SQL query. However, not all DBMSs conform to the standard, but most will allow you to use the Upper() function (Mysql, Postgres, Oracle). I think Access uses UCASE(). This allows you to just query select UCASE(S) as QV_field from ...

Re: Load Text(Upper(S)) ?

johanlind — Wed, 15 Jun 2011 13:33:16 GMT

I have tested both. If I do this:

LOAD upper(text(alpha)) as alpha INLINE [

alpha

01-0003-01

01-0003-1

01-0005-1

123456

];

I obtain 01-0003-01
01-0005-1
123456

If I do this:

LOAD text(upper(alpha)) as alpha INLINE [

alpha

01-0003-01

01-0003-1

01-0005-1

123456

];

I obtain 01-0003-01
01-0003-1
01-0005-1
123456

Re: Load Text(Upper(S)) ?

johanlind — Thu, 16 Jun 2011 06:21:42 GMT

Why do I get different results?

Re: Load Text(Upper(S)) ?

Anonymous — Wed, 25 Jun 2014 20:02:51 GMT

I am having similar problems. I have 2 SKUs 00056 and 0056. If I use Text(Upper I get 2 unique values. However, if I use Upper(Text I get only ONE value "00056". I believe this to be a bug, but I'm such a newbie that I don't even know where to log it.