Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

knightwriter
Contributor II

Month name change

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

Tags (3)
6 Replies
senpradip007
Valued Contributor III

Re: Month name change

Try this

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

Re: Month name change

Hi,

May be like this.

=left('Jan-14',3)

Regards

ASHFAQ

venkatasreekant
Valued Contributor

Re: Month name change

Try this:

In the script

Month(Fieldname)

MVP
MVP

Re: Month name change

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

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

knightwriter
Contributor II

Re: Month name change

Hi tresesco,

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

Thanks

venkatasreekant
Valued Contributor

Re: Month name change

In the Script level...

Community Browser