Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

anand_61
New Contributor

Handling of multiple date in data model

Hi ,

I have 2 fact table and from 1st fact table we are getting 3 date type field.(e.g: closed date ,open date ,delivery date ) and from fact table 2 we are getting different 2 date type fiels.

We have a master calender.

How can we make a data model with this.

Any leads will be appreciated.

2 Replies
ogautier62
Valued Contributor II

Re: Handling of multiple date in data model

Hi,

look at this :

Canonical Date

regards

shiveshsingh
Valued Contributor III

Re: Handling of multiple date in data model

You can use interval match function to match the dates and then link it with the calendar.

can you share some sample data to work upon?