https://community.qlik.com/t5/QlikView/Sum-data-with-same-ID/m-p/1836721#M1214951 <P>Hi everyone!</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="anjali1_0-1631801578087.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/62075iE7EC885BFCFE16F4/image-size/medium?v=v2&amp;px=400" role="button" title="anjali1_0-1631801578087.png" alt="anjali1_0-1631801578087.png" /></span></P><P>The data in the image shows the Pump Unavailability (%)&nbsp; for 3 different sites. I need to produce a table which sums the&nbsp;Pump Unavailability (%) for each site. &nbsp;Eventually I want a table like this:</P><P>Site Id:&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Pump Unavailability (%)</P><P>15553&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;31.45</P><P>15341&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;164.07</P><P>15002&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 21.39</P><P>Unfortunately, the Site Id and Pump Unavailability (%) data is in different tables. I did try to use a join function in the load script to join the tables, but it messed up my data.</P><P>Any suggestions on what to do? All help would be appreciated !</P> Thu, 16 Sep 2021 16:00:48 GMT anjali1 2021-09-16T16:00:48Z https://community.qlik.com/t5/QlikView/Sum-data-with-same-ID/m-p/1836721#M1214951 <P>Hi everyone!</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="anjali1_0-1631801578087.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/62075iE7EC885BFCFE16F4/image-size/medium?v=v2&amp;px=400" role="button" title="anjali1_0-1631801578087.png" alt="anjali1_0-1631801578087.png" /></span></P><P>The data in the image shows the Pump Unavailability (%)&nbsp; for 3 different sites. I need to produce a table which sums the&nbsp;Pump Unavailability (%) for each site. &nbsp;Eventually I want a table like this:</P><P>Site Id:&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Pump Unavailability (%)</P><P>15553&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;31.45</P><P>15341&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;164.07</P><P>15002&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 21.39</P><P>Unfortunately, the Site Id and Pump Unavailability (%) data is in different tables. I did try to use a join function in the load script to join the tables, but it messed up my data.</P><P>Any suggestions on what to do? All help would be appreciated !</P> Thu, 16 Sep 2021 16:00:48 GMT https://community.qlik.com/t5/QlikView/Sum-data-with-same-ID/m-p/1836721#M1214951 anjali1 2021-09-16T16:00:48Z https://community.qlik.com/t5/QlikView/Sum-data-with-same-ID/m-p/1836885#M1214952 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/149688">@anjali1</a>&nbsp;</P><P>I will move this to the QlikView app development board.&nbsp;</P> Fri, 17 Sep 2021 07:47:15 GMT https://community.qlik.com/t5/QlikView/Sum-data-with-same-ID/m-p/1836885#M1214952 Maria_Halley 2021-09-17T07:47:15Z