Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Combining Dimension

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

ItemReceived Date
AJune 2015
ADecember 2015
BDecember 2015

Example at  excel file B

Item Sent Out Date
AOctober 2015
ANovember 2015

Such that, my dimension would have June 2015 to December 2015. How can I achieve that?

1 Solution

Accepted Solutions
Highlighted
Specialist III
Specialist III

load

item ,

received date    as Date

from excel1;

load

item

sentoutdate as    Date

from excel2;

View solution in original post

4 Replies
Highlighted
Specialist III
Specialist III

load

item ,

received date    as Date

from excel1;

load

item

sentoutdate as    Date

from excel2;

View solution in original post

Highlighted
Not applicable

haha, Thanks.

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

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

Highlighted
Specialist III
Specialist III

no

Highlighted
Not applicable

Ok, Thanks Gowtham