Qlik Community

Qlik Sense App Development

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

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
jleefjcapital
Contributor II

Combining Year and Month Columns into a single Date column

Hello,

I'm trying to format my dates from the various data sources I'm getting my data from.  One data source represents the date by two separate columns (Year and Month).  I would like to combine these two columns into a single one, but also change the month format. 

For instance,

Year = YYYY

Month = M01

Date = JanYYYY

I hope someone could help me with this.

Thank you,

Jessica

1 Reply
Highlighted
MVP & Luminary
MVP & Luminary

Re: Combining Year and Month Columns into a single Date column

Hi Jessica,

your solution will include two parts:

1. Build a proper date field

2. Format the date field in the required way.

In order to build the proper date field, use the MakeDate function and only use the last 2 characters of the Month:

MakeDate(Year, Right(Month, 2))

Then enclose the same in the formatting function Date():

Date(MakeDate(Year, Right(Month, 2)), 'MMMYYYY')

That will do the job.

cheers,

Oleg Troyansky

Learn advanced QlikView and Qlik Sense techniques in my book QlikView Your Business