topic Re: Year and Month Format - YYYY_MM in QlikView

Year and Month Format - YYYY_MM

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

Hi All,

I have a requirement where the following Date Field (contains Year and Month only) needs to be converted into YYYY_MM format. Can somebody please advise on this. I have tried few options form my side but they are not giving the expected output.

Input YearMonth	Output YearMonth
2019_3	2019_03
2020_1	2020_01
2019_10	2019_10
2019_11	2019_11

The transformation is highlighted in blue/bold in Output YearMonth.

Thank you!

Regards,

Re: Year and Month Format - YYYY_MM

Taoufiq_Zarra — Mon, 13 Jul 2020 13:06:28 GMT

Hi,

Maye be ;

Date(Date#([Input YearMonth],'YYYY_MM'),'YYYY_MM') as [Output YearMonth]

output :

Re: Year and Month Format - YYYY_MM

sunny_talwar — Mon, 13 Jul 2020 13:23:08 GMT

May be this

Date(MakeDate(SubField(YearMonth, '_', 1), SubField(YearMonth, '_', -1)), 'YYYY-MM') as YearMonth

Re: Year and Month Format - YYYY_MM

sk88024 — Mon, 13 Jul 2020 13:30:48 GMT

Thanks Taoufiq. It worked. I was missing the second YYYY_MM in my trials.

Regards,