topic Connecting Tabels in QlikView https://community.qlik.com/t5/QlikView/Connecting-Tabels/m-p/690249#M249932 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>Can anyone please help me on the below Scenario?</P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">1. I have a master calendar with all dates in a year 2014 as table </SPAN><STRONG style="font-size: 10pt; line-height: 1.5em;">Calendar</STRONG><SPAN style="font-size: 10pt; line-height: 1.5em;">.</SPAN></P><P></P><P>2. And also i have another calender derived form Master calender as table <STRONG>Calendar 1</STRONG>.</P><P></P><P>3.I also have a another table loaded from excel spreadsheet as table <STRONG>Holidays 2014</STRONG>.</P><P></P><P>4.And also have last table named <STRONG>Working Days.</STRONG></P><P><STRONG>(</STRONG>I got this by comparing<STRONG> Calendar </STRONG>and<STRONG>&nbsp; Holidays 2014) </STRONG>used <SPAN style="text-decoration: underline;"><EM>where not Exists</EM></SPAN> function.</P><P></P><P>All i need is to re-Create table 4(<STRONG>Working Days</STRONG>) by connecting <SPAN style="font-size: 10pt; line-height: 1.5em;">table 1</SPAN><STRONG style="font-size: 10pt; line-height: 1.5em;">(Calendar)</STRONG><SPAN style="font-size: 10pt; line-height: 1.5em;"> and 3</SPAN><STRONG style="font-size: 10pt; line-height: 1.5em;">(Holidays 2014). </STRONG></P><P></P><P></P><P><STRONG><BR /></STRONG></P><P><STRONG><BR /></STRONG></P></BODY></HTML> Tue, 17 Jun 2014 04:43:01 GMT 2014-06-17T04:43:01Z Connecting Tabels https://community.qlik.com/t5/QlikView/Connecting-Tabels/m-p/690249#M249932 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>Can anyone please help me on the below Scenario?</P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">1. I have a master calendar with all dates in a year 2014 as table </SPAN><STRONG style="font-size: 10pt; line-height: 1.5em;">Calendar</STRONG><SPAN style="font-size: 10pt; line-height: 1.5em;">.</SPAN></P><P></P><P>2. And also i have another calender derived form Master calender as table <STRONG>Calendar 1</STRONG>.</P><P></P><P>3.I also have a another table loaded from excel spreadsheet as table <STRONG>Holidays 2014</STRONG>.</P><P></P><P>4.And also have last table named <STRONG>Working Days.</STRONG></P><P><STRONG>(</STRONG>I got this by comparing<STRONG> Calendar </STRONG>and<STRONG>&nbsp; Holidays 2014) </STRONG>used <SPAN style="text-decoration: underline;"><EM>where not Exists</EM></SPAN> function.</P><P></P><P>All i need is to re-Create table 4(<STRONG>Working Days</STRONG>) by connecting <SPAN style="font-size: 10pt; line-height: 1.5em;">table 1</SPAN><STRONG style="font-size: 10pt; line-height: 1.5em;">(Calendar)</STRONG><SPAN style="font-size: 10pt; line-height: 1.5em;"> and 3</SPAN><STRONG style="font-size: 10pt; line-height: 1.5em;">(Holidays 2014). </STRONG></P><P></P><P></P><P><STRONG><BR /></STRONG></P><P><STRONG><BR /></STRONG></P></BODY></HTML> Tue, 17 Jun 2014 04:43:01 GMT https://community.qlik.com/t5/QlikView/Connecting-Tabels/m-p/690249#M249932 2014-06-17T04:43:01Z