Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
you have to have a relationship between these tables in order to make links?
are you talking about MasterCalendar ?
No not a master table.
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