topic Upper in QlikView

Upper

Tue, 08 Jun 2010 13:12:36 GMT

Hi All,

The following is the SQL Server 2005 query:

select

UPPER (AddressLine1)

from

Person. Address

But How can i convert this query into Qlikview?

Best Regards,

Khalid

Upper

sparur — Tue, 08 Jun 2010 13:15:06 GMT

Hello, KHalid.

LOAD

Upper(AddressLine1) as AddressLine

;

sql select
AddressLine1
from
Person.Address

Upper

Tue, 08 Jun 2010 13:35:33 GMT

SQL Error:[Microsoft][SQL Native Client]Dialog failed
SQL State:IM008
select UPPER (AddressLine1)
from Person.Address

Upper

Tue, 08 Jun 2010 13:40:42 GMT

Try like this:

Upper(AddressLine1) as AddressLine

Upper

johnw — Wed, 09 Jun 2010 01:30:50 GMT


Khalid11 wrote:
SQL Error:[Microsoft][SQL Native Client]Dialog failed
SQL State:IM008
select UPPER (AddressLine1)
from Person.Address<div></div>

Please have another look at how Anatoly wrote the expression. See how the upper(AddressLine1) as AddressLine is done in the LOAD statement, not in the SQL statement? You appear to still be doing it in the SQL statement. If so, that is why you are getting an error. You need to do it in the LOAD statement instead.