topic Combining small and Caps in table in QlikView

Combining small and Caps in table

Wed, 07 Jan 2015 06:50:57 GMT

Hi All,

I have two similar values AAA & aaa. I want it to be displayed as aaa. can it be done by expression in the table?

Thanks,

Sai.

Re: Combining small and Caps in table

Wed, 07 Jan 2015 06:54:13 GMT

Capitalize worked.

Re: Combining small and Caps in table

morganaaron — Wed, 07 Jan 2015 08:59:52 GMT

Capitalize should show AAA or aaa as Aaa - if you want it all lower, you can use the Lower() function, similarly the Upper() function will stick it all in caps.

Re: Combining small and Caps in table

ThornOfCrowns — Wed, 07 Jan 2015 09:14:31 GMT

Please mark morganaaron's answer as correct, not your own response.