topic Re: Linking two fields with two different calendar in QlikView

Linking two fields with two different calendar

raju_salmon — Wed, 20 Apr 2016 14:16:57 GMT

Hi,

I have two DateID fields (in Fact table) where i need to map both ID's to different dimension tables available.

FACT:

DateID_Local,

DateID_TimeZone,

Fact1,

Fact2

DateTimeLocal:

DateID_Local,

Date,

Month,

Year etc

DateTimeTimeZone:

DateID_TimeZone,

Date,

Month,

Year etc

My requirement is to link two calendars to provide filter (always one selected value either DateTimeLocal or DateTimeTimeZone)... here i cannot able to concatenate these dim tables, because i need to link to two different UID field from Fact table.

Anyway to achieve the requirement?

Thanks for time.

Re: Linking two fields with two different calendar

sunny_talwar — Wed, 20 Apr 2016 14:19:07 GMT

Not sure I understand but are you wanting to have a single date (or other date related fields) control both these two dates field? Try this -> Canonical Date if that is what you are looking for.

Re: Linking two fields with two different calendar

raju_salmon — Wed, 20 Apr 2016 14:48:59 GMT

Thanks Sunny... My requirement to map two different calendar tables to two different Keys in Fact...

Since i am going to show month and year list box, i am looking to concatenate the both calender's...

I will check the above link.. thanks...