Discussion board where members can get started with QlikView.
I have a scenario like, I have a field with Upper case date. Let take
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
Go to Solution.
capitalize is enough. If you need string function in qlikview check below thread
View solution in original post
You can use the Capitalize function for that. Capitalize('TARUN') returns 'Tarun'.
Capitalize command is the right way to fulfill your requirement.