topic Re: Month name change in QlikView

Month name change

knightwriter — Wed, 21 May 2014 12:49:25 GMT

Hi All,

Quick and easy one for you! I have the months of the year as list box properties. My months are showing as Jan-14, Feb-14 etc, how do I change this to show Jan, Feb etc without manually changing all these in my excel spreadsheet.

Many thanks,

Stephen

Re: Month name change

senpradip007 — Wed, 21 May 2014 12:52:13 GMT

Try this

Date(Date#('Jan-14','MMM-YY'),'MMM')

Re: Month name change

ashfaq_haseeb — Wed, 21 May 2014 12:52:49 GMT

Hi,

May be like this.

=left('Jan-14',3)

Regards

ASHFAQ

Re: Month name change

Anonymous — Wed, 21 May 2014 12:53:39 GMT

Try this:

In the script

Month(Fieldname)

Re: Month name change

tresB — Wed, 21 May 2014 12:56:21 GMT

I recommend: =Month(Date#(YourField , 'MMM-YY'))

This gives you output which is responsive to all date functions.

Re: Month name change

knightwriter — Wed, 21 May 2014 13:52:58 GMT

Hi tresesco,

Where do I use this formula? The script or excel?

Thanks

Re: Month name change

Anonymous — Wed, 21 May 2014 14:01:13 GMT

In the Script level...