topic Link tables by Week Day in QlikView https://community.qlik.com/t5/QlikView/Link-tables-by-Week-Day/m-p/760973#M1048719 <HTML><HEAD></HEAD><BODY><P>I have 2 tables that I would like to link by week day and from my various searches it appears that interval match with a calendar may be the best alternative.&nbsp; I've been using Qlikview for about year and this would be the first time I have a need for the calendar and the use of interval match.&nbsp; Another aspect that I believe may complicate the issue is the fact that one of my fields (StoreOpenDay) from the Hours table is not necessarily a date but a numeric value to represent the day of the week which I've converted to week day in the load script, 'Mon', 'Tue','Wed', etc.&nbsp; The other week day field (WeekDay) is an actual date derived from the Orders table.&nbsp; Can anyone provide a simple solution that would accomplish this task? Please see the attached QVW illustrating my issue. Thanks in advance for any assistance.</P></BODY></HTML> Mon, 17 Nov 2014 16:00:40 GMT 2014-11-17T16:00:40Z Link tables by Week Day https://community.qlik.com/t5/QlikView/Link-tables-by-Week-Day/m-p/760973#M1048719 <HTML><HEAD></HEAD><BODY><P>I have 2 tables that I would like to link by week day and from my various searches it appears that interval match with a calendar may be the best alternative.&nbsp; I've been using Qlikview for about year and this would be the first time I have a need for the calendar and the use of interval match.&nbsp; Another aspect that I believe may complicate the issue is the fact that one of my fields (StoreOpenDay) from the Hours table is not necessarily a date but a numeric value to represent the day of the week which I've converted to week day in the load script, 'Mon', 'Tue','Wed', etc.&nbsp; The other week day field (WeekDay) is an actual date derived from the Orders table.&nbsp; Can anyone provide a simple solution that would accomplish this task? Please see the attached QVW illustrating my issue. Thanks in advance for any assistance.</P></BODY></HTML> Mon, 17 Nov 2014 16:00:40 GMT https://community.qlik.com/t5/QlikView/Link-tables-by-Week-Day/m-p/760973#M1048719 2014-11-17T16:00:40Z