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: 
Anonymous
Not applicable

Can anybody explain about how many way we can format the upper case

Hi Everyone,

I have a scenario like, I have a field with Upper case date. Let take

Tab1:

Name,

Age,

Salary

Dept

From xyz.xlsx

In field "Name"(ex: TARUN) I have all upper case data and I would like to convert it as "First letter upper and Remaining in lower" (ex: Tarun).

How many ways I can try to convert it into this format.

I have used.

1: CAPITAL function

2. Upper() & Mid()

It will be helpful if there is any other way to convert.

Thanks in advance

Varun K

1 Solution

Accepted Solutions
PrashantSangle

Hi,

capitalize is enough. If you need string function in qlikview check below thread

http://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/StringFunctions/string-...

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

View solution in original post

4 Replies
Gysbert_Wassenaar

You can use the Capitalize function for that. Capitalize('TARUN') returns 'Tarun'.


talk is cheap, supply exceeds demand
PrashantSangle

Hi,

capitalize is enough. If you need string function in qlikview check below thread

http://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/StringFunctions/string-...

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
Anonymous
Not applicable
Author

Thank you gwassenaar and @prashant

sankartalluru
Contributor III
Contributor III

Hi,

Capitalize command is the right way to fulfill your requirement.