Monthname

[curiousfellow]

In my data there is a number representing the number of the month.

It is possible to select several months.

The highest monthnumber is stored to a variable 'monthnumber'

In my report I want the name of the highest month to be displayed.

I tried : date('10-'&($(monthnumber))&'-2000','mmm') and several other expressions using monthname or monthnames.

Unfortunately nothing works.

I don't want the year to be displayed.

Pleez help this newbie

[sujeetsingh]

Use MonthName() function of Qlikview.

It will be better if you provide a sample.

[jduenyas]

Try this:

Replace the hyphen with a forward slash

month(date('10/' & monthnumber & '/2000'))

[jduenyas]

Monthname() functions returns the Year with the month and he does not want to see year.

[JonnyPoole]

This will work for you. Replace '10' with the field that provides a month number. 

= date(MakeDate(2000,10),'MMM')   -->   'Oct'

=date(MakeDate(2000,[MonthNumberField]),'MMM')  ->   the 3 digit month name

[Anonymous]

Hi,

month(date#(Date,'MMM')) as Month

[curiousfellow]

Thanks to all of you for your quick reply. I use Jonathans solution.

[rwunderlich]

For the record, here's another alternative:

=month(date#(monthNumberField,'M'))

-Rob

[JonnyPoole]

hello curiousfellow. thanks for the update and glad it worked out. 

if you are good to go i suggest closing the thread and marking the helpful posts. 

let us know if you have any other questions