Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ali_hijazi
Partner
Partner

Get the month name from fiscal period

Hello 
got a fact table in which I have the fiscal year and period; the fiscal year starts on April
so in a row of data I might have the following rows with the respective year and period values

2021 1
2021 2
2021 3
....
I want to translate these into 
2021 April
2021 May
2021 June
...
kindly advise

I can walk on water when it freezes
1 Solution

Accepted Solutions
tresesco
MVP
MVP

You can try like:

=Month(MonthName(Date#(Month,'M'),3))

View solution in original post

4 Replies
MayilVahanan

HI 

You can use Mapping & ApplyMap for this or pick & match function like

Pick(Match(Month, 1,2,3,4,5,6,7,8,9,10,11,12), 'Apr', 'May', 'Jun', 'Jul', 'Aug','Sep','Oct','Nov', 'Dec', 'Jan', 'Feb', 'Mar')

Thanks & Regards,
Mayil Vahanan R
ali_hijazi
Partner
Partner
Author

isn't there any function to do it other than the mapping table?
the thing is that I don't want to modify the script so thought there would be any function and use in the chart

I can walk on water when it freezes
MayilVahanan

You can try with Pick & Match function as mentioned in the earlier post

Thanks & Regards,
Mayil Vahanan R
tresesco
MVP
MVP

You can try like:

=Month(MonthName(Date#(Month,'M'),3))

View solution in original post