Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
New Contributor III

Combine two dimension to one

Hi All

I have a problem concerning two dates dimension from two different tables.

I've solve the problem when looking at months by doing below.


However, I also have to look into weeks and days. And doing that the same way as above would be to much work, and inefficient.

So how can i accomplish above solution in another more simpel way?



1 Reply
Valued Contributor II

Re: Combine two dimension to one

In the environment variables Changes monthnames as below

SET MonthNames='January;February;March;April;May;June;July;August;September;October;November;December';

and use the below code in dimention

=If(BookingMonth and Month(Orderdate)=1,BookingMonth &'-'& Month(MakeDate(2018,BookingMonth)))

Community Browser