Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Prabhu1204
Creator
Creator

How to Link Date Filed without having linking filed

Is it possible to Link Filed to another table without having linking fileds,

my sale  table has below column 

sale_no,

sale_date,

sale_description

 Fact table has the column

sale_date_key

Date Table has the column

Date_key.

Using date_key and sale_date_key.. i am linking  my fact table and date table..

How to link the date column to the sale table.. There is no common filed names.

When i tried the Cartesian product is forming.

-Prabhu
Labels (1)
3 Replies
Taoufiq_Zarra

you have to have a relationship between these tables in order to make links?

are you talking about MasterCalendar ?

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
Prabhu1204
Creator
Creator
Author

No not a master table. 

-Prabhu
Brett_Bleess
Former Employee
Former Employee

Have a look at the following Design Blog post, this is to what Taoufiq was referring in his post and I concur this would appear to be what you are trying to do:

https://community.qlik.com/t5/Qlik-Design-Blog/The-Master-Calendar/ba-p/1471527

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.