How to combine column containing Year, Month and Day into Table?

[#1]

How to combine this individual column in the main dataset (Table A) to:

Table A

Year	Month	Day
2015	1	31
2015	2	1

Single column combining everything together in a summary table on Qlikview dashboard?

Table B

Date
31/1/2015
1/2/2015

[ramoncova06 · Accepted solution]

you can use make date

MakeDate(YYYY [ , MM [ , DD ] ] )

Returns a date calculated from the year YYYY, the month MM and the day DD.

If no month is stated, 1(January) is assumed.

If no day is stated, 1 (the 1:st) is assumed.

Examples:

makedate(1999) returns 1999-01-01

makedate(99) returns 0099-01-01

makedate(1992,12) returns 1992-12-01

makedate(1999,2,14) returns 1999-02-14

[jpenuliar]

Makedate(Year,Month,Day) as Derived_Date 

[rmdnkevin]

I'm using ramoncova06‌ 's script ( MakeDate(YYYY [ , MM [ , DD ] ] ) ) to generate 1 date column.

Can ayone help me to make the full script to combine it ?

Thanks a lot