topic Re: Monthname in QlikView

Monthname

curiousfellow — Fri, 23 Jan 2015 18:41:15 GMT

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 — Fri, 23 Jan 2015 18:48:27 GMT

Use MonthName() function of Qlikview.

It will be better if you provide a sample.

jduenyas — Fri, 23 Jan 2015 18:50:53 GMT

Try this:

Replace the hyphen with a forward slash

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

jduenyas — Fri, 23 Jan 2015 18:52:13 GMT

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

JonnyPoole — Fri, 23 Jan 2015 19:03:43 GMT

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 — Fri, 23 Jan 2015 19:09:30 GMT

Hi,

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

curiousfellow — Fri, 23 Jan 2015 19:51:00 GMT

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

rwunderlich — Fri, 23 Jan 2015 20:44:42 GMT

For the record, here's another alternative:

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

-Rob

JonnyPoole — Fri, 23 Jan 2015 21:31:39 GMT

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