Hi Qlikers,
Say, I have two sets of dates, 2 from different excel file. I wanted to have do this MonthName(Date([Date1])) union with MonthName(Date([Date2])).
Example at excel file A
| Item | Received Date |
|---|
| A | June 2015 |
| A | December 2015 |
| B | December 2015 |
Example at excel file B
| Item | Sent Out Date |
|---|
| A | October 2015 |
| A | November 2015 |
Such that, my dimension would have June 2015 to December 2015. How can I achieve that?
