topic Re: equivalent function of inticap() in qlikview in QlikView

equivalent function of inticap() in qlikview

jelly_gvm — Thu, 31 Oct 2013 11:15:41 GMT

Hi All,

is there any similar or equivalent function of inticap()(SQL function) is avaliable in qlikview

Thanks,

swuehl — Thu, 31 Oct 2013 11:21:43 GMT

You mean Initcap() function, right?

Please check the Help for all string functions, then you should get around

capitalize(s )

Returns the string s with all words capitalized.

Example:

capitalize ('my little pony') returns 'My Little Pony'

capitalize ( 'AA bb cC Dd') returns 'Aa Bb Cc Dd'

jelly_gvm — Fri, 15 Nov 2013 07:24:36 GMT

sorry to say delay response

thanks a lot