Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
varunk3366
New Contributor III

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

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

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.

View solution in original post

4 Replies
MVP & Luminary
MVP & Luminary

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

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


talk is cheap, supply exceeds demand

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

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.

View solution in original post

varunk3366
New Contributor III

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

Thank you gwassenaar and @prashant

sankartalluru
New Contributor III

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

Hi,

Capitalize command is the right way to fulfill your requirement.