https://community.qlik.com/t5/App-Development/Calculate-the-sum-with-condition/m-p/1643666#M48147 <P>Why not 34 since there is no restrict on first 3 fields not the time?&nbsp; What is the output for below?</P><P>Operation&nbsp; &nbsp;Status&nbsp; &nbsp; &nbsp; &nbsp;Date&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Time&nbsp;</P><P>1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;OK&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 11/12/2019 &nbsp; &nbsp; 34&nbsp;</P><P>1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;OK&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 11/12/2019 &nbsp; &nbsp; 23</P><P>2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;OK&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;11/13/2019&nbsp; &nbsp; &nbsp; 2324</P><P>3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; NOK&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;11/14/2019&nbsp; &nbsp; &nbsp; 234</P><P>Note: If you are looking row wise data of First one please clarify us?</P> Wed, 06 Nov 2019 10:49:01 GMT Anil_Babu_Samineni 2019-11-06T10:49:01Z https://community.qlik.com/t5/App-Development/Calculate-the-sum-with-condition/m-p/1643653#M48146 <P>Hi, i want to calculate</P><P>Sum of time for all operations that went ok first time it run</P><P>Operation&nbsp; &nbsp;Status&nbsp; &nbsp; &nbsp; &nbsp;Date&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Time&nbsp;</P><P>1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;OK&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 11/12/2019&nbsp; &nbsp; &nbsp;23&nbsp;</P><P>1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;OK&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 11/12/2019&nbsp; &nbsp; &nbsp;34</P><P>2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;OK&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;11/13/2019&nbsp; &nbsp; &nbsp; 2324</P><P>3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; NOK&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;11/14/2019&nbsp; &nbsp; &nbsp; 234</P><P>&nbsp;</P><P>&nbsp;</P><P>Should be for operation 1 =&nbsp; 23&nbsp;</P><P>&nbsp;</P> Wed, 06 Nov 2019 10:25:30 GMT https://community.qlik.com/t5/App-Development/Calculate-the-sum-with-condition/m-p/1643653#M48146 Jogi 2019-11-06T10:25:30Z https://community.qlik.com/t5/App-Development/Calculate-the-sum-with-condition/m-p/1643666#M48147 <P>Why not 34 since there is no restrict on first 3 fields not the time?&nbsp; What is the output for below?</P><P>Operation&nbsp; &nbsp;Status&nbsp; &nbsp; &nbsp; &nbsp;Date&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Time&nbsp;</P><P>1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;OK&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 11/12/2019 &nbsp; &nbsp; 34&nbsp;</P><P>1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;OK&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 11/12/2019 &nbsp; &nbsp; 23</P><P>2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;OK&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;11/13/2019&nbsp; &nbsp; &nbsp; 2324</P><P>3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; NOK&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;11/14/2019&nbsp; &nbsp; &nbsp; 234</P><P>Note: If you are looking row wise data of First one please clarify us?</P> Wed, 06 Nov 2019 10:49:01 GMT https://community.qlik.com/t5/App-Development/Calculate-the-sum-with-condition/m-p/1643666#M48147 Anil_Babu_Samineni 2019-11-06T10:49:01Z https://community.qlik.com/t5/App-Development/Calculate-the-sum-with-condition/m-p/1643674#M48148 <P>Hi, sorry&nbsp; poor explanation&nbsp;</P><P>1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;OK&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 11/12/2019 &nbsp; &nbsp; 34&nbsp;</P><P><STRONG>1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;OK&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10/12/2019 &nbsp; &nbsp; 23</STRONG></P><P>2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;OK&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;11/13/2019&nbsp; &nbsp; &nbsp; 2324</P><P>3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; NOK&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;11/14/2019&nbsp; &nbsp; &nbsp; 234</P><P>&nbsp;</P><P>should be first OK for Number 1 + number 2 OK&nbsp; &nbsp;= 23+ 2324&nbsp;</P><P>So i need to select only min(Ok) for each ID and make the sum</P><P>Does it help please let me know /&nbsp;&nbsp;</P> Wed, 06 Nov 2019 10:57:37 GMT https://community.qlik.com/t5/App-Development/Calculate-the-sum-with-condition/m-p/1643674#M48148 Jogi 2019-11-06T10:57:37Z