https://community.qlik.com/t5/App-Development/Condition-on-two-columns-to-count-visits/m-p/1690850#M52789 <P>I have two tables:</P><P>1. Readmission</P><P>The readmission table contains readmission visits with columns Readmit_PatientID, Readmit_VisitID, Readmit_AdmitDateTime, PrevAdmit_VisitID, PrevAdmit_DischargeDateTime.</P><P>Readmit_VisitID is unique in the Readmission table.</P><P>2. All_Visits</P><P>The All Visits table contains all the visits with columns Patient_ID, VisitServiceDateTime, VisitID.&nbsp;</P><P>VisitID is unique in the All_Visits table.</P><P>The two tables are joined by Readmission.Prev_VisitID and AllVisits.VisitID</P><P>I need to find the number of Visits between the PrevAdmit_DischargeDateTime and Readmit_AdmitDateTime.</P> Fri, 03 Apr 2020 16:48:19 GMT sharasridhar 2020-04-03T16:48:19Z https://community.qlik.com/t5/App-Development/Condition-on-two-columns-to-count-visits/m-p/1690850#M52789 <P>I have two tables:</P><P>1. Readmission</P><P>The readmission table contains readmission visits with columns Readmit_PatientID, Readmit_VisitID, Readmit_AdmitDateTime, PrevAdmit_VisitID, PrevAdmit_DischargeDateTime.</P><P>Readmit_VisitID is unique in the Readmission table.</P><P>2. All_Visits</P><P>The All Visits table contains all the visits with columns Patient_ID, VisitServiceDateTime, VisitID.&nbsp;</P><P>VisitID is unique in the All_Visits table.</P><P>The two tables are joined by Readmission.Prev_VisitID and AllVisits.VisitID</P><P>I need to find the number of Visits between the PrevAdmit_DischargeDateTime and Readmit_AdmitDateTime.</P> Fri, 03 Apr 2020 16:48:19 GMT https://community.qlik.com/t5/App-Development/Condition-on-two-columns-to-count-visits/m-p/1690850#M52789 sharasridhar 2020-04-03T16:48:19Z