topic How to capitalize(Month) in QlikView

How to capitalize(Month)

Fri, 08 Jul 2011 16:03:19 GMT

Hi,

I have a field with data like Jan 2011.

But, some values are in JAN 2011, some are Jan 2011.

How can i standardize all to says Jan 2011?

i tried the following, but i didn't work.

DATE#(capitalize(MONTH_YEAR), 'MMM YYYY') as MONTH_YEAR,

Re: How to capitalize(Month)

nagaiank — Fri, 08 Jul 2011 16:08:40 GMT

Try the following expression:

Date(Date#(YourDate,'MMM YYYY'),'MMM YYYY')

How to capitalize(Month)

Fri, 08 Jul 2011 16:10:49 GMT

Thanks, but still the same.

How to capitalize(Month)

jedgson — Fri, 08 Jul 2011 16:29:54 GMT

use:

upper(Yourdate)

Jay

Re: How to capitalize(Month)

nagaiank — Fri, 08 Jul 2011 16:34:57 GMT

What I suggested works for me, unless I did not understand your requirement.

See the attached file.

How to capitalize(Month)

Fri, 08 Jul 2011 20:33:32 GMT

ok, but it still didn't work for my case.

upper() will change all to upper but wont keep the date format..

any other way?

Re: How to capitalize(Month)

nagaiank — Fri, 08 Jul 2011 20:38:54 GMT

My logic is as simple as this. If it is not working for you, either your data is not what you think it is or the processing is erroneous. From my example, I am able to establish the processing seems to be correct. Let us then examine your data and what you are doing. If you can attach a sample data and your script, the forum may be able to help.

How to capitalize(Month)

Fri, 08 Jul 2011 21:07:00 GMT

ok, if i put that in expression, it works, but in fact, i'm doin it in the script. that's why it wont work.

whats the different formatting it in expression and in the script?

Re: How to capitalize(Month)

nagaiank — Fri, 08 Jul 2011 21:15:46 GMT

It works in load script also. See the attached file to believe it.

How to capitalize(Month)

danielrozental — Mon, 25 Jul 2011 19:13:25 GMT

Try

LOAD

capitalize(FULL_NAME) AS FULL_NAME;

select

P.EMPLOYEE AS FULL_NAME

FROM SDDTA.PhoneReport P

How to capitalize(Month)

Mon, 25 Jul 2011 19:14:54 GMT

getting errors

How to capitalize(Month)

danielrozental — Mon, 25 Jul 2011 19:21:18 GMT

That doesn't give us much to work with and help you, post your script.

How to capitalize(Month)

Mon, 25 Jul 2011 19:42:54 GMT

Never mind, I got..Thank you so much for your help though

How to capitalize(Month)

erichshiino — Tue, 26 Jul 2011 00:50:37 GMT

Going back to the syntax of your first post, maybe you just need to include the month names in a capitalized form in the beggining of the script:

SET MonthNames='JAN;FEB;MAR ...

Hope this helps,

Erich