topic Need help with for loop in Qlikview. in QlikView https://community.qlik.com/t5/QlikView/Need-help-with-for-loop-in-Qlikview/m-p/818199#M1037523 <HTML><HEAD></HEAD><BODY><P><BR />Hi,</P><P>I am getting audit log details from incident management system in the format attached. For each incident I need to calculate, total time took to resolve the incident. I want to exclude the time for which incident had status: Pending in log details field.</P><P>The time information is stored in field Audit Date.</P><P></P><P>The process goes like this:</P><P>1. fetch all records related to a particular incident from the available incoming data.</P><P>2. start calculating resolution time where log contains "Assignee: John" value till the time when log contains "Status: Resolved"</P><P>3. subtract the time where log contains "Status: Pending&nbsp; (3)" till the status is changed to "Status: In Progress "</P><P></P><P>Any ideas how to use loop for this?</P></BODY></HTML> Mon, 05 Jan 2015 14:51:34 GMT nesawant 2015-01-05T14:51:34Z Need help with for loop in Qlikview. https://community.qlik.com/t5/QlikView/Need-help-with-for-loop-in-Qlikview/m-p/818199#M1037523 <HTML><HEAD></HEAD><BODY><P><BR />Hi,</P><P>I am getting audit log details from incident management system in the format attached. For each incident I need to calculate, total time took to resolve the incident. I want to exclude the time for which incident had status: Pending in log details field.</P><P>The time information is stored in field Audit Date.</P><P></P><P>The process goes like this:</P><P>1. fetch all records related to a particular incident from the available incoming data.</P><P>2. start calculating resolution time where log contains "Assignee: John" value till the time when log contains "Status: Resolved"</P><P>3. subtract the time where log contains "Status: Pending&nbsp; (3)" till the status is changed to "Status: In Progress "</P><P></P><P>Any ideas how to use loop for this?</P></BODY></HTML> Mon, 05 Jan 2015 14:51:34 GMT https://community.qlik.com/t5/QlikView/Need-help-with-for-loop-in-Qlikview/m-p/818199#M1037523 nesawant 2015-01-05T14:51:34Z