Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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.

loveqliksense
Not applicable

Upper Case and Lower case

Hi All,

This is my script. Here, Fields in NAME are displayed in Lower Case and ID in upper case. I want both of them to be displayed as Lower case. How can I do it??

"NAME"&'-'&

              Applymap('MAP',ID) as Location#1,

Thanks in advance

3 Replies
sunny_talwar
Not applicable

Re: Upper Case and Lower case

May be this

Lower("NAME"&'-'&Applymap('MAP',ID)) as Location#1,

loveqliksense
Not applicable

Re: Upper Case and Lower case

Thanks...It works but I want First Letter of the fIeld to be capital . How can I do it?

sunny_talwar
Not applicable

Re: Upper Case and Lower case

Try Capitalize then

Capitalize("NAME"&'-'&Applymap('MAP',ID)) as Location#1,