Discussion Board for collaboration on QlikView Scripting.
I have month and date in 2 separate columns on a spread sheet but want a MonthName (Jan 2013)
I have already converted month into a proper date (Month(Date#((Left(Month,3)),'MMM')) as Month,) and year (Year(Date#(Year,'YYYY')) as Year,)
Now how can I combine the 2 to from a MonthName?
Go to Solution.
MonthName (Date#(Left(Month,3)&Year, 'MMMYYYY')) as MonthName
It worked perfectly!!!