topic Re: Combining month and year in QlikView

Combining month and year

nkosinde13 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Combining month and year

tresB — Fri, 11 Oct 2019 11:28:06 GMT

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

Re: Combining month and year

nkosinde13 — Fri, 11 Oct 2019 11:49:12 GMT

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

sunny_talwar — Fri, 11 Oct 2019 11:57:59 GMT

May be try this

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