topic Find Status based on min and max dates in QlikView https://community.qlik.com/t5/QlikView/Find-Status-based-on-min-and-max-dates/m-p/66786#M458523 <HTML><HEAD></HEAD><BODY><P>Hi experts,</P><P>I have a requirement sample data attached.</P><P></P><P>1)I have mobile numbers and enquirers came from on online other sources(2 sources). find the mobile number came from which source first based on date fields.</P><P></P><P>2)based on enquiry need recent status.</P><P></P><P>TIA</P><P>Regards</P><P>Pavan</P></BODY></HTML> Wed, 21 Feb 2018 16:56:26 GMT Anonymous 2018-02-21T16:56:26Z Find Status based on min and max dates https://community.qlik.com/t5/QlikView/Find-Status-based-on-min-and-max-dates/m-p/66786#M458523 <HTML><HEAD></HEAD><BODY><P>Hi experts,</P><P>I have a requirement sample data attached.</P><P></P><P>1)I have mobile numbers and enquirers came from on online other sources(2 sources). find the mobile number came from which source first based on date fields.</P><P></P><P>2)based on enquiry need recent status.</P><P></P><P>TIA</P><P>Regards</P><P>Pavan</P></BODY></HTML> Wed, 21 Feb 2018 16:56:26 GMT https://community.qlik.com/t5/QlikView/Find-Status-based-on-min-and-max-dates/m-p/66786#M458523 Anonymous 2018-02-21T16:56:26Z Re: Find Status based on min and max dates https://community.qlik.com/t5/QlikView/Find-Status-based-on-min-and-max-dates/m-p/66787#M458524 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>you can use flags to create a new column on each source.</P></BODY></HTML> Wed, 21 Feb 2018 17:10:19 GMT https://community.qlik.com/t5/QlikView/Find-Status-based-on-min-and-max-dates/m-p/66787#M458524 YoussefBelloum 2018-02-21T17:10:19Z