Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have few different dates coming from different fact tables in my Data model and I am trying to link those dates with the Master calendar.
Can anyone please give the solution on linking those dates.
Hi,
Can you please share the script ?
I can't share the script but i can send you the screenshot of what is coming wrong on front end.
Will that work?
Hi,
Please check for the individual tables values if its correct then there is a problem with the linking dimension and measure values respective of Dates.
Try to follow the Link table concept: http://www.qlikfix.com/2016/09/08/elegant-link-table-script/
hoping that you will be able to resolve this.
Best,
BK
I have snowflake schema, how link table can be created on that schema?
I don't have common Id's in all the fact tables.
Outstanding and Purchase Requisition tables are linked on Department Id to Event Report table .
Further, Purchase Requisition table is linked to Purchase Order on Requistion Id whereas,
Billing Tracking System and Purchase Order tables are linked to each other on Vendor Id
I have tried concatenating these tables but data doesn't get associated properly
Please help in giving solution on Linking these tables to master calender other than link table and it's an urgent requirement.
hi,
please find below my understating, please correct me about dates and other link fields if it wrong
That's correct except the Invoice Date is in Outstanding table and Bill Date is in BTS table.
Hi
Any solution?
Hold on