Is there any function like Proper in xls?

[rahulhv1]

If i a select dimention as customer name , and if the name is  like  'Example ONE'   it should appera like 'Example One'

[agilos_mla]

Use Capitalize([YourField])

Michael

[ashwanin]

In QlikView this Proper command is performed by function Capitalize, While upper is still same.

You have to put the below in script.

Capitalize ([Customer]) as [Customer]. It will provide you the required format.

[luis_pimentel]

Use:

     Capitalie(fielname) as fieldanmeCapitalized