topic Returns in QlikView https://community.qlik.com/t5/QlikView/Returns/m-p/1316411#M408665 <HTML><HEAD></HEAD><BODY><P>Good day,</P><P></P><P>I am looking to find the number of time a patients returns from ICU to a particular department and back.&nbsp; Here are the fields that I am working with.</P><P></P><P>PAT_Encounter_CSN</P><P>Event ID</P><P>FromTime</P><P>ToTime</P><P>firstDepartment</P><P>NextDepartment</P><P> <BR />My approach I created flags from ICU to Depart A and Department A back to ICU, this would be a single return.&nbsp;&nbsp; I have a solution for returns, my issue is that if a patient has more than one return that happens in a month, and if the next return ends in the next month, both of the returns are counted in the same month.&nbsp; Thanks for the assistance.</P></BODY></HTML> Mon, 17 Jul 2017 07:44:45 GMT detmawin 2017-07-17T07:44:45Z Returns https://community.qlik.com/t5/QlikView/Returns/m-p/1316411#M408665 <HTML><HEAD></HEAD><BODY><P>Good day,</P><P></P><P>I am looking to find the number of time a patients returns from ICU to a particular department and back.&nbsp; Here are the fields that I am working with.</P><P></P><P>PAT_Encounter_CSN</P><P>Event ID</P><P>FromTime</P><P>ToTime</P><P>firstDepartment</P><P>NextDepartment</P><P> <BR />My approach I created flags from ICU to Depart A and Department A back to ICU, this would be a single return.&nbsp;&nbsp; I have a solution for returns, my issue is that if a patient has more than one return that happens in a month, and if the next return ends in the next month, both of the returns are counted in the same month.&nbsp; Thanks for the assistance.</P></BODY></HTML> Mon, 17 Jul 2017 07:44:45 GMT https://community.qlik.com/t5/QlikView/Returns/m-p/1316411#M408665 detmawin 2017-07-17T07:44:45Z