Merge Month and Year beside each other in qlikview

[#1]

Hi,

I have Year and Month fields in QlikView and I need YearMonth beside each other like:

Year:2015

Month:05

YearMonth: 201505

How can I do it?

[sunny_talwar]

Try this:

Date(MakeDate(Year, Month, 1), 'YYYYMM') as YearMonth

[sunny_talwar]

or

Date#(Year&Month, 'YYYYMM') as YearMonth

[Anonymous]

Try this:

Date(MakeDate(YEAR, MONTH), 'YYYYMM') as YearMonth

[amit_saini]

Hi,

Try this in backend:

Year(Datefield) & ' ' & Month(Datefield) as YearMonth

Thanks,

AS

[Kushal_Chawda]

Create Field in script

date#(Year &Month,'YYYYMM') as YearMonth

[#7]

concat fields in edit script to get result

Year&Month as YearMonth

concat fields as a calculated dimension to use in any Qlikview object

or also use same in list box defining custom expression.

Year&Month

Regards,

Zain.