Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Luukvoskamp
Contributor
Contributor

link Date variables

Hello,

I have an issue with my data. 

How do i link my data Begroting periode (BudgetMonth) in Jaar(Year) with my calendar so that it links with my costs. 

At this moment I don`t know how to connect these variables to make a year-month-budget-costs table

budget.PNGKosten.PNG

Hope someone can help me.

Thanks in advance

Luuk

Labels (3)
3 Replies
lanlizgu
Creator III
Creator III

you can create a YEAR-MONTH field in each table so that they could be linked.

Luukvoskamp
Contributor
Contributor
Author

Does that automatically link to my master calendar as well?

lanlizgu
Creator III
Creator III

if you have two fields with the same date in two different tables they are linked automatically yes. You need to ensure that both fields data is in the same format so the link could be coherent.