topic Re: Help with script to join tables in QlikView https://community.qlik.com/t5/QlikView/Help-with-script-to-join-tables/m-p/1417950#M614659 <HTML><HEAD></HEAD><BODY><P>May be by creating a link table. Check here? If this helps:</P><P></P><P><A href="http://www.learnallbi.com/link-table-in-qlikview/" title="http://www.learnallbi.com/link-table-in-qlikview/">Link Table in QlikView – Learn QlikView</A></P></BODY></HTML> Tue, 26 Sep 2017 16:29:38 GMT vishsaggi 2017-09-26T16:29:38Z Help with script to join tables https://community.qlik.com/t5/QlikView/Help-with-script-to-join-tables/m-p/1417949#M614658 <HTML><HEAD></HEAD><BODY><P>Hi I have a question! </P><P></P><P>These are (a few of) my dimensions in my QlikSense app:</P><P></P><P><STRONG>Fact table:</STRONG></P><P>DateKey (when work was performed)</P><P>UtilisationKey (date when work was performed + employeenumber)</P><P><SPAN style="font-size: 13.3333px;">EmployeeKey</SPAN></P><P><SPAN style="font-size: 10pt;">OrganizationalUnit (e.g. Org_Unit1)</SPAN></P><P><SPAN style="font-size: 10pt;">HoursRegistered (hours someone worked on a certain date)</SPAN></P><P><SPAN style="font-size: 10pt;">UPFA (Unplanned fee adjustments)<BR /></SPAN></P><P><SPAN style="font-size: 10pt;">...</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;"><STRONG>Utilisation table:</STRONG></SPAN></P><P><SPAN style="font-size: 10pt;">UtilisationKey</SPAN></P><P><SPAN style="font-size: 10pt;">AvailableHours</SPAN></P><P><SPAN style="font-size: 10pt;">EmployeeNumber_Util</SPAN></P><P><SPAN style="font-size: 10pt;">...</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;"><STRONG>Employee table:</STRONG></SPAN></P><P><SPAN style="font-size: 13.3333px;">EmployeeKey</SPAN></P><P><SPAN style="font-size: 13.3333px;">OrganizationalUnit_Emp (e.g. Unit 1)</SPAN></P><P><SPAN style="font-size: 13.3333px;">OrganizationalTeam (e.g. Team 1)</SPAN></P><P><SPAN style="font-size: 13.3333px;">...<BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;"><STRONG>Date table:</STRONG></SPAN></P><P><SPAN style="font-size: 13.3333px;">DateKey</SPAN></P><P><SPAN style="font-size: 13.3333px;">...<BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">I need to count the utilisation for a person, which is HoursRegistered / AvailableHours and then I want to visualise that persons belonging to a Organizational unit and team. </SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">But the problem is that the people that are in the fact table are the only ones who actually have registered hours, and not the ones who were only available. </SPAN><SPAN style="font-size: 13.3333px;">So I want to add the persons who have null() HoursRegistered but have HoursAvailable (in the Utilisation table) to the fact table, put the null() to 0, and then also connect an organisational unit and team to each of them. But the information about those persons is only in the Employee Table and in another format than it is in the fact table (e.g. <SPAN style="font-size: 13.3333px;">Org_Unit1 </SPAN>vs. <SPAN style="font-size: 13.3333px;">Unit 1</SPAN>)</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Any suggestions and script examples how I can solve this? <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> </SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Big thanks!</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Maria<BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P></P></BODY></HTML> Tue, 26 Sep 2017 14:16:05 GMT https://community.qlik.com/t5/QlikView/Help-with-script-to-join-tables/m-p/1417949#M614658 Anonymous 2017-09-26T14:16:05Z Re: Help with script to join tables https://community.qlik.com/t5/QlikView/Help-with-script-to-join-tables/m-p/1417950#M614659 <HTML><HEAD></HEAD><BODY><P>May be by creating a link table. Check here? If this helps:</P><P></P><P><A href="http://www.learnallbi.com/link-table-in-qlikview/" title="http://www.learnallbi.com/link-table-in-qlikview/">Link Table in QlikView – Learn QlikView</A></P></BODY></HTML> Tue, 26 Sep 2017 16:29:38 GMT https://community.qlik.com/t5/QlikView/Help-with-script-to-join-tables/m-p/1417950#M614659 vishsaggi 2017-09-26T16:29:38Z Re: Help with script to join tables https://community.qlik.com/t5/QlikView/Help-with-script-to-join-tables/m-p/1417951#M614660 <HTML><HEAD></HEAD><BODY><P>worked with join. Thanks anyway</P></BODY></HTML> Tue, 24 Oct 2017 07:00:57 GMT https://community.qlik.com/t5/QlikView/Help-with-script-to-join-tables/m-p/1417951#M614660 Anonymous 2017-10-24T07:00:57Z Re: Help with script to join tables https://community.qlik.com/t5/QlikView/Help-with-script-to-join-tables/m-p/1417952#M614661 <HTML><HEAD></HEAD><BODY><P>Is your question now answered / problem solved or still open?</P></BODY></HTML> Tue, 24 Oct 2017 07:28:08 GMT https://community.qlik.com/t5/QlikView/Help-with-script-to-join-tables/m-p/1417952#M614661 oknotsen 2017-10-24T07:28:08Z