topic How to bind 2 tables data and sum from third table in QlikView https://community.qlik.com/t5/QlikView/How-to-bind-2-tables-data-and-sum-from-third-table/m-p/291073#M1203070 <HTML><HEAD></HEAD><BODY><P>Hi friends,<BR />I have data source in following format:<BR /><BR />table "ProjectData":<BR /> IDMyProject MyProjectName<BR /> 1 project 01<BR /> 1 project 02<BR /> ...<BR /><BR />table "DeliverableData":<BR /> IDMyProject IDMyDeliverable IDMyProjectDeliverable MyDeliverableName MyDeliverableStartDate MyDeliverableEndDate<BR /> 1 1 1 deliverable P01-01 1.1.2010 31.1.2010<BR /> 1 2 2 deliverable P01-02 15.1.2010 15.2.2010<BR /> ...<BR /><BR />table "DeliverableRealWorkingActivity":<BR /> IDMyProject IDMyDeliverable IDMyProjectDeliverable IDWorkingJob WorkingDate DurationOfWorking MyDeliverableSource<BR /> 1 1 1 1 1.1.2010 45 JC<BR /> 1 1 1 2 5.1.2010 60 JC<BR /> 1 1 1 3 3.1.2010 100 AB<BR /> 1 1 1 4 4.1.2010 120 AB<BR /> ...<BR /><BR />I would like to build following data:<BR /> IDMyProject MyProjectName IDMyDeliverable IDMyProjectDeliverable MyDeliverableName MyDeliverableStartDate MyDeliverableEndDate SumOfWorkingDurationForAllSources<BR /> 1 project 01 1 1 deliverable P01-01 1.1.2010 31.1.2010 325<BR /> 1 project 01 2 2 deliverable P01-02 15.1.2010 15.2.2010 ...<BR /> ...<BR /><BR />where last column "SumOfWorkingDurationForAllSources" would be calculated sum of all rows (values "DurationOfWorking") of table "DeliverableRealWorkingActivity" for each "IDMyProject" and "IDMyDeliverable".<BR /><BR />Does anybody have some idea, how can I write script to load these data and create mentioned structure of data?</P><P>very thanks</P></BODY></HTML> Mon, 29 Nov 2010 11:47:50 GMT 2010-11-29T11:47:50Z How to bind 2 tables data and sum from third table https://community.qlik.com/t5/QlikView/How-to-bind-2-tables-data-and-sum-from-third-table/m-p/291073#M1203070 <HTML><HEAD></HEAD><BODY><P>Hi friends,<BR />I have data source in following format:<BR /><BR />table "ProjectData":<BR /> IDMyProject MyProjectName<BR /> 1 project 01<BR /> 1 project 02<BR /> ...<BR /><BR />table "DeliverableData":<BR /> IDMyProject IDMyDeliverable IDMyProjectDeliverable MyDeliverableName MyDeliverableStartDate MyDeliverableEndDate<BR /> 1 1 1 deliverable P01-01 1.1.2010 31.1.2010<BR /> 1 2 2 deliverable P01-02 15.1.2010 15.2.2010<BR /> ...<BR /><BR />table "DeliverableRealWorkingActivity":<BR /> IDMyProject IDMyDeliverable IDMyProjectDeliverable IDWorkingJob WorkingDate DurationOfWorking MyDeliverableSource<BR /> 1 1 1 1 1.1.2010 45 JC<BR /> 1 1 1 2 5.1.2010 60 JC<BR /> 1 1 1 3 3.1.2010 100 AB<BR /> 1 1 1 4 4.1.2010 120 AB<BR /> ...<BR /><BR />I would like to build following data:<BR /> IDMyProject MyProjectName IDMyDeliverable IDMyProjectDeliverable MyDeliverableName MyDeliverableStartDate MyDeliverableEndDate SumOfWorkingDurationForAllSources<BR /> 1 project 01 1 1 deliverable P01-01 1.1.2010 31.1.2010 325<BR /> 1 project 01 2 2 deliverable P01-02 15.1.2010 15.2.2010 ...<BR /> ...<BR /><BR />where last column "SumOfWorkingDurationForAllSources" would be calculated sum of all rows (values "DurationOfWorking") of table "DeliverableRealWorkingActivity" for each "IDMyProject" and "IDMyDeliverable".<BR /><BR />Does anybody have some idea, how can I write script to load these data and create mentioned structure of data?</P><P>very thanks</P></BODY></HTML> Mon, 29 Nov 2010 11:47:50 GMT https://community.qlik.com/t5/QlikView/How-to-bind-2-tables-data-and-sum-from-third-table/m-p/291073#M1203070 2010-11-29T11:47:50Z How to bind 2 tables data and sum from third table https://community.qlik.com/t5/QlikView/How-to-bind-2-tables-data-and-sum-from-third-table/m-p/291074#M1203071 <HTML><HEAD></HEAD><BODY><P>hi friends,</P><P>voila! I find solution! Loading script may be following:</P><P>TempCostsProjectData:<BR />LOAD IDMyProject,<BR /> MyProjectName<BR />FROM Test.xls (biff, embedded labels, table is ProjectData$);<BR />JOIN LOAD<BR /> IDMyProject,<BR /> IDMyDeliverable,<BR /> IDMyProjectDeliverable,<BR /> MyDeliverableName,<BR /> MyDeliverableStartDate,<BR /> MyDeliverableEndDate<BR />FROM Test.xls (biff, embedded labels, table is DeliverableData$);<BR />JOIN LOAD<BR /> IDMyProject,<BR /> IDMyDeliverable,<BR /> IDMyProjectDeliverable,<BR /> <B>Sum(DurationOfWorking) AS SumDurationOfWorking<BR /></B>FROM Test.xls (biff, embedded labels, table is DeliverableRealWorkingActivity$)<BR /><B>GROUP BY IDMyProject, IDMyDeliverable, IDMyProjectDeliverable</B>;<BR /><BR />CostsProjectData:<BR />LOAD IDMyProject,<BR /> MyProjectName,<BR /> IDMyDeliverable,<BR /> IDMyProjectDeliverable,<BR /> MyDeliverableName,<BR /> MyDeliverableStartDate,<BR /> MyDeliverableEndDate,<BR /> SumDurationOfWorking<BR />Resident TempCostsProjectData;</P></BODY></HTML> Mon, 29 Nov 2010 14:27:53 GMT https://community.qlik.com/t5/QlikView/How-to-bind-2-tables-data-and-sum-from-third-table/m-p/291074#M1203071 2010-11-29T14:27:53Z