Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
load
item ,
received date as Date
from excel1;
load
item
sentoutdate as Date
from excel2;
load
item ,
received date as Date
from excel1;
load
item
sentoutdate as Date
from excel2;
haha, Thanks.
Forgot that I could combine the sets in the Load Editor.
But is there a way to do it in the expression?
no
Ok, Thanks Gowtham