Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
MayilVahanan

Hi,

     Try like this,

     Load Upper(UserName) as UserName;

     select UserName from customerproducts;

Hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

8 Replies
MayilVahanan

Hi,

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

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
CELAMBARASAN
Partner - Champion
Partner - Champion

Upper will work for sure in script

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

Not applicable
Author

I am trying to

'select Upper(Username) from customerproducts'

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

MayilVahanan

Hi,

     Try like this,

     Load Upper(UserName) as UserName;

     select UserName from customerproducts;

Hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Not applicable
Author

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

CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     Then MayilVahanan Suggestion will help you.

     Which vendor database your using?

MayilVahanan

Hi,

     Try like this,

     Load *, Upper(UserName) as UserName;

     select * ,UserName from customerproducts;

     What result it gave? Did satisfy your requirement?

Hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Not applicable
Author

Thanks, it worked when I added a load statement.