Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
nkosinde13
Contributor

Combining month and year

Good day community

I have month name e.g Jan, Feb etc.. and year e.g 2018,2019 etc and need to combine the two to make one date. I've tried a couple of expressions like below and none seem to work: 

Date(Date#([Fin Month Name F], 'MMM') & '-' & [Fin Year F], 'MMM-YYYY')

Date(MakeDate([Fin Year F], Month(Date#([Fin Month Name F], 'MMM'))),'MMM-YYYY')

Any help is greatly appreciated.

Thanks

Matlotlo

 

1 Solution

Accepted Solutions
MVP
MVP

Re: Combining month and year

Your second expression should work. If not, try to share a sample showing the issue.

View solution in original post

3 Replies
MVP
MVP

Re: Combining month and year

Your second expression should work. If not, try to share a sample showing the issue.

View solution in original post

nkosinde13
Contributor

Re: Combining month and year

Oh thank you. I see now where I was getting it wrong, just a silly error. It is actually working with the second expression, I've been selecting only a month on list boxes instead of both month and year, that's why it was giving me '-'. 

Thanks

Matlotlo

Re: Combining month and year

May be try this

Date(Date#([Fin Month Name F] & '-' & [Fin Year F], 'MMM-YYYY'), 'MMM-YYYY')