topic Re: Finding start date and End date in QlikView https://community.qlik.com/t5/QlikView/Finding-start-date-and-End-date/m-p/1114281#M368045 <HTML><HEAD></HEAD><BODY><P>another one</P><P></P><P>start</P><P><EM>=makedate(Year, div(Index('$(MonthNames)', Month), 4)+1)</EM></P><P></P><P>end is <EM>monthend</EM>........</P></BODY></HTML> Tue, 02 Aug 2016 18:42:58 GMT maxgro 2016-08-02T18:42:58Z Finding start date and End date https://community.qlik.com/t5/QlikView/Finding-start-date-and-End-date/m-p/1114278#M368042 <HTML><HEAD></HEAD><BODY><P>Hi Friends,</P><P></P><P>Please let me know if any one can Help in Finding start date and End date of the selected month, For the Attached QVW file.</P><P></P><P><IMG alt="Img1.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/133382_Img1.PNG" style="height: 350px; width: 620px;" /></P><P></P><P></P><P><IMG alt="Img2.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/133383_Img2.PNG" style="height: auto;" /></P><P></P><P></P><P></P><P>Regards,</P><P></P><P>Pooja</P></BODY></HTML> Tue, 02 Aug 2016 18:17:09 GMT https://community.qlik.com/t5/QlikView/Finding-start-date-and-End-date/m-p/1114278#M368042 2016-08-02T18:17:09Z Re: Finding start date and End date https://community.qlik.com/t5/QlikView/Finding-start-date-and-End-date/m-p/1114279#M368043 <HTML><HEAD></HEAD><BODY><P>I have edited your example file.&nbsp; Please see the attached.</P></BODY></HTML> Tue, 02 Aug 2016 18:21:31 GMT https://community.qlik.com/t5/QlikView/Finding-start-date-and-End-date/m-p/1114279#M368043 Nicole-Smith 2016-08-02T18:21:31Z Re: Finding start date and End date https://community.qlik.com/t5/QlikView/Finding-start-date-and-End-date/m-p/1114280#M368044 <HTML><HEAD></HEAD><BODY><P>This?</P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/133384_Capture.PNG" style="height: 326px; width: 620px;" /></P><P></P><P>Expressions:</P><P>start date</P><P><STRONG>=Date(MakeDate(Min(Year),Min(Month(Date#(Month, 'MMM'))), 1))</STRONG></P><P></P><P>End date</P><P><STRONG>=Date(Floor(MonthEnd(MakeDate(Min(Year),Min(Month(Date#(Month, 'MMM'))), 1))))</STRONG></P></BODY></HTML> Tue, 02 Aug 2016 18:24:37 GMT https://community.qlik.com/t5/QlikView/Finding-start-date-and-End-date/m-p/1114280#M368044 sunny_talwar 2016-08-02T18:24:37Z Re: Finding start date and End date https://community.qlik.com/t5/QlikView/Finding-start-date-and-End-date/m-p/1114281#M368045 <HTML><HEAD></HEAD><BODY><P>another one</P><P></P><P>start</P><P><EM>=makedate(Year, div(Index('$(MonthNames)', Month), 4)+1)</EM></P><P></P><P>end is <EM>monthend</EM>........</P></BODY></HTML> Tue, 02 Aug 2016 18:42:58 GMT https://community.qlik.com/t5/QlikView/Finding-start-date-and-End-date/m-p/1114281#M368045 maxgro 2016-08-02T18:42:58Z