Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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.

Måned.PNG

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?

-----------

Stefan

1 Reply
techvarun
Specialist II
Specialist II

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)))