topic SUM in load script in App Development https://community.qlik.com/t5/App-Development/SUM-in-load-script/m-p/1595291#M43802 <P>In SQL I have 1 table, and when i do this SQL i get the result i need.&nbsp;</P><P>"SELECT t1._KeyID,<BR />t1._Tmp_TIME,<BR />t1._TmpID,<BR />sum(q1.FLAG) as xSUM<BR />FROM Table1 t1<BR />LEFT JOIN Table1 t2 on t2._KeyID = t1._KeyID<BR />WHERE (t2._Tmp_TIME between t1._Tmp_TIME and t1._Tmp_END_TIME<BR />AND t1._Tmp_IDX &lt;&gt; t2._Tmp_IDX)<BR />GROUP BY t1._KeyID, t1._Tmp_TIME,t1._TmpID"</P><P>&nbsp;</P><P>Table1:</P><TABLE><TBODY><TR><TD>_KeyID</TD><TD>_TmpID</TD><TD>_Tmp_IDX</TD><TD>_Tmp_TIME</TD><TD>_Tmp_END_TIME</TD><TD>FLAG</TD></TR><TR><TD>22062019|10026|411458</TD><TD>114040943</TD><TD>13746</TD><TD>08:36:20.0000000</TD><TD>08:37:20.0000000</TD><TD>1</TD></TR><TR><TD>22062019|10026|411458</TD><TD>114040944</TD><TD>13746</TD><TD>08:36:21.0000000</TD><TD>08:37:21.0000000</TD><TD>1</TD></TR><TR><TD>22062019|10026|411458</TD><TD>114040945</TD><TD>13746</TD><TD>08:36:23.0000000</TD><TD>08:37:23.0000000</TD><TD>1</TD></TR><TR><TD>22062019|10026|411458</TD><TD>114040932</TD><TD>13746</TD><TD>08:36:24.0000000</TD><TD>08:37:24.0000000</TD><TD>1</TD></TR><TR><TD>22062019|10026|411458</TD><TD>114040643</TD><TD>13746</TD><TD>08:36:26.0000000</TD><TD>08:37:26.0000000</TD><TD>1</TD></TR><TR><TD>22062019|10026|411458</TD><TD>114040644</TD><TD>13746</TD><TD>08:36:26.0000000</TD><TD>08:37:26.0000000</TD><TD>1</TD></TR><TR><TD>22062019|10026|411458</TD><TD>114040645</TD><TD>13900</TD><TD>08:36:28.0000000</TD><TD>08:37:28.0000000</TD><TD>1</TD></TR><TR><TD>22062019|10026|411458</TD><TD>114040646</TD><TD>13900</TD><TD>08:36:30.0000000</TD><TD>08:37:30.0000000</TD><TD>1</TD></TR><TR><TD>22062019|10026|411458</TD><TD>114040647</TD><TD>13577</TD><TD>08:36:32.0000000</TD><TD>08:37:32.0000000</TD><TD>1</TD></TR><TR><TD>22062019|10026|411458</TD><TD>114040648</TD><TD>13726</TD><TD>08:36:37.0000000</TD><TD>08:37:37.0000000</TD><TD>1</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Result of SQL:</P><TABLE><TBODY><TR><TD>_KeyID</TD><TD>_Tmp_TIME</TD><TD>_TmpID</TD><TD>xSUM</TD></TR><TR><TD>22062019|10026|411458</TD><TD>08:36:20.0000000</TD><TD>114040943</TD><TD>4</TD></TR><TR><TD>22062019|10026|411458</TD><TD>08:36:21.0000000</TD><TD>114040944</TD><TD>4</TD></TR><TR><TD>22062019|10026|411458</TD><TD>08:36:23.0000000</TD><TD>114040945</TD><TD>4</TD></TR><TR><TD>22062019|10026|411458</TD><TD>08:36:24.0000000</TD><TD>114040932</TD><TD>4</TD></TR><TR><TD>22062019|10026|411458</TD><TD>08:36:26.0000000</TD><TD>114040643</TD><TD>4</TD></TR><TR><TD>22062019|10026|411458</TD><TD>08:36:26.0000000</TD><TD>114040644</TD><TD>4</TD></TR><TR><TD>22062019|10026|411458</TD><TD>08:36:28.0000000</TD><TD>114040645</TD><TD>2</TD></TR><TR><TD>22062019|10026|411458</TD><TD>08:36:30.0000000</TD><TD>114040646</TD><TD>2</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>The Table1 is easy to enough to create as&nbsp; a resident table in LOAD script, but my mind is tired and fresh out of ideas to in converting the SQL Select to LOAD SCRIPT.</P><P>So how do i do this in the LOAD SCRIPT?</P><P>&nbsp;</P><P>Note: The data i'm normally loads comes from QVDs</P><P>&nbsp;</P><P>&nbsp;</P> Sat, 16 Nov 2024 20:35:49 GMT larsrosenm 2024-11-16T20:35:49Z SUM in load script https://community.qlik.com/t5/App-Development/SUM-in-load-script/m-p/1595291#M43802 <P>In SQL I have 1 table, and when i do this SQL i get the result i need.&nbsp;</P><P>"SELECT t1._KeyID,<BR />t1._Tmp_TIME,<BR />t1._TmpID,<BR />sum(q1.FLAG) as xSUM<BR />FROM Table1 t1<BR />LEFT JOIN Table1 t2 on t2._KeyID = t1._KeyID<BR />WHERE (t2._Tmp_TIME between t1._Tmp_TIME and t1._Tmp_END_TIME<BR />AND t1._Tmp_IDX &lt;&gt; t2._Tmp_IDX)<BR />GROUP BY t1._KeyID, t1._Tmp_TIME,t1._TmpID"</P><P>&nbsp;</P><P>Table1:</P><TABLE><TBODY><TR><TD>_KeyID</TD><TD>_TmpID</TD><TD>_Tmp_IDX</TD><TD>_Tmp_TIME</TD><TD>_Tmp_END_TIME</TD><TD>FLAG</TD></TR><TR><TD>22062019|10026|411458</TD><TD>114040943</TD><TD>13746</TD><TD>08:36:20.0000000</TD><TD>08:37:20.0000000</TD><TD>1</TD></TR><TR><TD>22062019|10026|411458</TD><TD>114040944</TD><TD>13746</TD><TD>08:36:21.0000000</TD><TD>08:37:21.0000000</TD><TD>1</TD></TR><TR><TD>22062019|10026|411458</TD><TD>114040945</TD><TD>13746</TD><TD>08:36:23.0000000</TD><TD>08:37:23.0000000</TD><TD>1</TD></TR><TR><TD>22062019|10026|411458</TD><TD>114040932</TD><TD>13746</TD><TD>08:36:24.0000000</TD><TD>08:37:24.0000000</TD><TD>1</TD></TR><TR><TD>22062019|10026|411458</TD><TD>114040643</TD><TD>13746</TD><TD>08:36:26.0000000</TD><TD>08:37:26.0000000</TD><TD>1</TD></TR><TR><TD>22062019|10026|411458</TD><TD>114040644</TD><TD>13746</TD><TD>08:36:26.0000000</TD><TD>08:37:26.0000000</TD><TD>1</TD></TR><TR><TD>22062019|10026|411458</TD><TD>114040645</TD><TD>13900</TD><TD>08:36:28.0000000</TD><TD>08:37:28.0000000</TD><TD>1</TD></TR><TR><TD>22062019|10026|411458</TD><TD>114040646</TD><TD>13900</TD><TD>08:36:30.0000000</TD><TD>08:37:30.0000000</TD><TD>1</TD></TR><TR><TD>22062019|10026|411458</TD><TD>114040647</TD><TD>13577</TD><TD>08:36:32.0000000</TD><TD>08:37:32.0000000</TD><TD>1</TD></TR><TR><TD>22062019|10026|411458</TD><TD>114040648</TD><TD>13726</TD><TD>08:36:37.0000000</TD><TD>08:37:37.0000000</TD><TD>1</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Result of SQL:</P><TABLE><TBODY><TR><TD>_KeyID</TD><TD>_Tmp_TIME</TD><TD>_TmpID</TD><TD>xSUM</TD></TR><TR><TD>22062019|10026|411458</TD><TD>08:36:20.0000000</TD><TD>114040943</TD><TD>4</TD></TR><TR><TD>22062019|10026|411458</TD><TD>08:36:21.0000000</TD><TD>114040944</TD><TD>4</TD></TR><TR><TD>22062019|10026|411458</TD><TD>08:36:23.0000000</TD><TD>114040945</TD><TD>4</TD></TR><TR><TD>22062019|10026|411458</TD><TD>08:36:24.0000000</TD><TD>114040932</TD><TD>4</TD></TR><TR><TD>22062019|10026|411458</TD><TD>08:36:26.0000000</TD><TD>114040643</TD><TD>4</TD></TR><TR><TD>22062019|10026|411458</TD><TD>08:36:26.0000000</TD><TD>114040644</TD><TD>4</TD></TR><TR><TD>22062019|10026|411458</TD><TD>08:36:28.0000000</TD><TD>114040645</TD><TD>2</TD></TR><TR><TD>22062019|10026|411458</TD><TD>08:36:30.0000000</TD><TD>114040646</TD><TD>2</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>The Table1 is easy to enough to create as&nbsp; a resident table in LOAD script, but my mind is tired and fresh out of ideas to in converting the SQL Select to LOAD SCRIPT.</P><P>So how do i do this in the LOAD SCRIPT?</P><P>&nbsp;</P><P>Note: The data i'm normally loads comes from QVDs</P><P>&nbsp;</P><P>&nbsp;</P> Sat, 16 Nov 2024 20:35:49 GMT https://community.qlik.com/t5/App-Development/SUM-in-load-script/m-p/1595291#M43802 larsrosenm 2024-11-16T20:35:49Z