Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
evansabres
Specialist
Specialist

Transforming a Date

Hello -

I have a field called [Line item start date] which is in the format MM/DD/YYYY

I have created an inline table:

MonthMap:
Mapping LOAD * INLINE
[ mntNA, mntNM 
Jan, 01 
Feb, 02 
Mar, 03 
Apr, 04 
May, 05 
Jun, 06 
Jul, 07 
Aug, 08 
Sep, 09 
Oct, 10 
Nov, 11 
Dec, 12 ]
;

How can I apply this map to my date field so that the numerical months appear alphabetically. My end game is to create a list box of months and years.

Thank you.

Labels (1)
0 Replies