topic link Date variables in QlikView

link Date variables

Luukvoskamp — Sat, 16 Nov 2024 03:05:47 GMT

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

Hope someone can help me.

Thanks in advance

Luuk

Re: link Date variables

lanlizgu — Thu, 04 Jul 2019 09:55:56 GMT

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

Re: link Date variables

Luukvoskamp — Thu, 04 Jul 2019 10:15:34 GMT

Does that automatically link to my master calendar as well?

Re: link Date variables

lanlizgu — Thu, 04 Jul 2019 10:56:00 GMT

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.