Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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
gautik92
Valued Contributor III

Re: Combining Dimension

load

item ,

received date    as Date

from excel1;

load

item

sentoutdate as    Date

from excel2;

4 Replies
gautik92
Valued Contributor III

Re: Combining Dimension

load

item ,

received date    as Date

from excel1;

load

item

sentoutdate as    Date

from excel2;

Not applicable

Re: Combining Dimension

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
Valued Contributor III

Re: Combining Dimension

no

Not applicable

Re: Combining Dimension

Ok, Thanks Gowtham

Community Browser