Combining Dimension

[#1]

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?

[gautik92 · Accepted solution]

load

item ,

received date    as Date

from excel1;

load

item

sentoutdate as    Date

from excel2;

[#3]

haha, Thanks.

Forgot that I could combine the sets in the Load Editor.

But is there a way to do it in the expression?

[gautik92]

no

[#5]

Ok, Thanks Gowtham