Discussion board where members can get started with QlikView.
I have a year field and a month field that shows Jan, Feb, Mar, Apr, etx. My load script also already has :
It is probably easy but I cannot seem to get these fields in a format such as Apr 2017. The issue is I need to create a rolling 12 month flag so I didnt think Month&' '&Year would work. Any help is appreciated.
Go to Solution.
If you have a year field too, try like:
MonthName(MakeDate(YearField, Month(Date#(MonthField, 'MMM'))) as MonthName
You need to do like below? MonthName(DateField) as MonthName
Or you can try this
Date(Date#(Month&Year, 'MMMYYYY'), 'MMM YYYY') as MonthYear