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

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

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Gysbert_Wassenaar — Fri, 23 Dec 2016 12:00:18 GMT

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

PrashantSangle — Fri, 23 Dec 2016 12:02:08 GMT

Hi,

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

Regards

Anonymous — Wed, 28 Dec 2016 06:14:39 GMT

sankartalluru — Wed, 28 Dec 2016 06:44:37 GMT

Hi,

Capitalize command is the right way to fulfill your requirement.