topic Re: re: month end in QlikView https://community.qlik.com/t5/QlikView/re-month-end/m-p/816214#M287872 <HTML><HEAD></HEAD><BODY><P>If you have Calendar table, then add Month End Date to this table</P></BODY></HTML> Mon, 30 Mar 2015 06:12:03 GMT anbu1984 2015-03-30T06:12:03Z re: month end https://community.qlik.com/t5/QlikView/re-month-end/m-p/816212#M287870 <HTML><HEAD></HEAD><BODY><P>HI all..</P><P></P><P>need help please...</P><P></P><P>i have to get the month end of the selected period...</P><P>i have month ,year,monthyear,week,quarter in my selections..if any of this is selected then i need to get the max of month end of the date.</P><P></P><P>how can it b done..</P><P></P><P>please suggest</P></BODY></HTML> Mon, 30 Mar 2015 06:01:42 GMT https://community.qlik.com/t5/QlikView/re-month-end/m-p/816212#M287870 2015-03-30T06:01:42Z Re: re: month end https://community.qlik.com/t5/QlikView/re-month-end/m-p/816213#M287871 <HTML><HEAD></HEAD><BODY><P>Hi Reena,</P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">You can use <SPAN style="color: #ff0000;"><STRONG>MonthEnd</STRONG></SPAN> function. See below example from help file.</SPAN></P><P></P><P><IMG __jive_id="82292" alt="Capture.PNG" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/82292_Capture.PNG" style="height: 92px; width: 620px;" /></P></BODY></HTML> Mon, 30 Mar 2015 06:11:45 GMT https://community.qlik.com/t5/QlikView/re-month-end/m-p/816213#M287871 tamilarasu 2015-03-30T06:11:45Z Re: re: month end https://community.qlik.com/t5/QlikView/re-month-end/m-p/816214#M287872 <HTML><HEAD></HEAD><BODY><P>If you have Calendar table, then add Month End Date to this table</P></BODY></HTML> Mon, 30 Mar 2015 06:12:03 GMT https://community.qlik.com/t5/QlikView/re-month-end/m-p/816214#M287872 anbu1984 2015-03-30T06:12:03Z Re: re: month end https://community.qlik.com/t5/QlikView/re-month-end/m-p/816215#M287873 <HTML><HEAD></HEAD><BODY><P>Try use this</P><P>Monthend(Max(Date))</P></BODY></HTML> Mon, 30 Mar 2015 06:13:28 GMT https://community.qlik.com/t5/QlikView/re-month-end/m-p/816215#M287873 senpradip007 2015-03-30T06:13:28Z