Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
gerhardl
Contributor II

Proper Case

Hi,

Is there something like the excel Proper function I can use in QV?

I have fields where our system shows all stores in UPPERCASE, I want to change them all to Proper Case. I've played around with the Force statement but this seems to be for Field Names, I just want to change the field values.

Like I would use the number function...

Regards,

Gerhard

1 Solution

Accepted Solutions
Not applicable

Re: Proper Case

I think you are looking for the capitalize() funtion. Used just like lower() or upper().

2 Replies
Not applicable

Re: Proper Case

I think you are looking for the capitalize() funtion. Used just like lower() or upper().

Proper Case

Hi,

   Try Capitalize() to achieve this.

   Here is an example

  

   capitalize ( 'my little pony' )

   returns 'My Little Pony'

   capitalize ( 'AA bb cC Dd' )

    returns 'Aa Bb Cc Dd'

Regards,

Kaushik Solanki

Community Browser