Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

month long names

Hello All;

I have month selection and I need to show the selected month in a long month name format. Like January, February ...

my month data is like: Jan, Feb, Mar, Apr, ..

date(month,'MMMM') show the long month name format but I need to show the selected months' long month names.

For to get the selected month I have tried:

'GetFieldSelections(month)' and than applied date function like below

'date(GetFieldSelections(month),'MMMM')' and it is not worked.

Do you have any suggestion for this issue.

regards;

Onur Y.

5 Replies
Highlighted

How about this

Concat(DISTINCT Date(SetDateYear(MonthStart(month), Year(Today()), 'MMMM'), ', ')

Specialist II
Specialist II

The Match function finds the index of Month in the MonthNames variable.  The SubField function uses the index to extract the field from the LongMonthNames.

=SubField(LongMonthNames,';',Match(Month, $(=chr(39) & Replace(MonthNames, ';', chr(39) & ',' & chr(39)) & chr(39))))


If you don't have a calendar table, I would strongly recommend creating one.  It really helps displaying different date formats.  See How to create a Calendar

Highlighted
Partner
Partner

Hi Onur,

May be it helps you , It  works for me:

=Date(Date#(GetFieldSelections(month),'MMM'),'MMMM')

Thanks,

Arvind Patil

Highlighted

Does this work even when you have multiple selections?

Highlighted
Specialist
Specialist

=Concat(Date(Date#(GetFieldSelections(month),'MMM'),'MMMM'), ', ')