Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
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
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
Makedate(Year,Month,Day) as Derived_Date
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