topic Re: Upper Case in QlikView

Upper Case

Thu, 12 Jul 2012 20:37:21 GMT

Hi,

I am trying to load data and make it all upper case, but upper() does not work in the script. Is there any other way to load all the data as uppercase, or to make Qlikview not case sensitive?

Thanks

Re: Upper Case

MayilVahanan — Thu, 12 Jul 2012 20:44:00 GMT

Hi,

You can use, Upper(FieldName) in script, its working.. Can you post a sample file ..Its help to achieve the requirement

Re: Upper Case

CELAMBARASAN — Thu, 12 Jul 2012 20:45:55 GMT

Upper will work for sure in script

Can you tell me why your going for Case insensitive operation?

Re: Upper Case

Thu, 12 Jul 2012 20:48:36 GMT

I am trying to

'select Upper(Username) from customerproducts'

and I get an error box that reads 'OLEDB read failed'

Re: Upper Case

MayilVahanan — Thu, 12 Jul 2012 20:52:45 GMT

Hi,

Try like this,

Load Upper(UserName) as UserName;

select UserName from customerproducts;

Hope it helps

Re: Upper Case

Thu, 12 Jul 2012 20:57:54 GMT

In the database there are information with names, sometimes written in all caps and sometimes not, but it is still the same name. I want the same names, no matter what case, to be grouped together in a table box..

Thanks

Re: Upper Case

CELAMBARASAN — Thu, 12 Jul 2012 21:05:17 GMT

Hi,

Then MayilVahanan Suggestion will help you.

Which vendor database your using?

Re: Upper Case

MayilVahanan — Thu, 12 Jul 2012 21:06:23 GMT

Hi,

Try like this,

Load *, Upper(UserName) as UserName;

select * ,UserName from customerproducts;

What result it gave? Did satisfy your requirement?

Hope it helps

Re: Upper Case

Thu, 12 Jul 2012 21:56:52 GMT

Thanks, it worked when I added a load statement.