topic Re: Is there any function like Proper in xls? in QlikView

Is there any function like Proper in xls?

rahulhv1 — Tue, 11 Feb 2014 09:48:07 GMT

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

agilos_mla — Tue, 11 Feb 2014 09:49:46 GMT

Use Capitalize([YourField])

Michael

ashwanin — Tue, 11 Feb 2014 10:05:47 GMT

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 — Tue, 11 Feb 2014 10:55:08 GMT

Use:

Capitalie(fielname) as fieldanmeCapitalized