Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Upper Case

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

1 Solution

Accepted Solutions

Re: Upper Case

Hi,

     Try like this,

     Load Upper(UserName) as UserName;

     select UserName from customerproducts;

Hope it helps

8 Replies

Re: Upper Case

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

Upper will work for sure in script

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

Not applicable

Re: Upper Case

I am trying to

'select Upper(Username) from customerproducts'

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

Re: Upper Case

Hi,

     Try like this,

     Load Upper(UserName) as UserName;

     select UserName from customerproducts;

Hope it helps

Not applicable

Re: Upper Case

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

Hi,

     Then MayilVahanan Suggestion will help you.

     Which vendor database your using?

Re: Upper Case

Hi,

     Try like this,

     Load *, Upper(UserName) as UserName;

     select * ,UserName from customerproducts;

     What result it gave? Did satisfy your requirement?

Hope it helps

Not applicable

Re: Upper Case

Thanks, it worked when I added a load statement.