Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

how can we get starting letter of a word capital when data in database in all capital letters

how can we get starting letter of a word capital when data in database in all capital letters

3 Replies
oknotsen
Honored Contributor III

Re: how can we get starting letter of a word capital when data in database in all capital letters

Use the Capitalize function:

Capitalize - script and chart function ‒ Qlik Sense

May you live in interesting times!
OmarBenSalem
Esteemed Contributor

Re: how can we get starting letter of a word capital when data in database in all capital letters

=Capitalize( Lower(YourField))

Capture.PNG

viveksingh
Contributor II

Re: how can we get starting letter of a word capital when data in database in all capital letters

Capitalize(Field_Name)

this gives data like below

Dheeraj

Ram

Raj

Vijay

Sreekanth