topic Re: Month end data in straight table in QlikView https://community.qlik.com/t5/QlikView/Month-end-data-in-straight-table/m-p/544702#M1125201 <HTML><HEAD></HEAD><BODY><P>Flagging the month end date in the script using the MonthEnd function and a simple set analysis expression in the straight table will perhaps produce the results you are looking for. </P><P></P><P><STRONG>Script </STRONG><STRONG>Example</STRONG></P><P>IF(YourDate = MonthEnd(YourDate),1,0) as MonthEndFlag</P><P></P><P><STRONG>Month End Sales Field</STRONG></P><P>=SUM({$&lt;MonthEndFlag={1}&gt;}SalesAmount)</P></BODY></HTML> Thu, 02 Jan 2014 16:59:34 GMT 2014-01-02T16:59:34Z Month end data in straight table https://community.qlik.com/t5/QlikView/Month-end-data-in-straight-table/m-p/544701#M1125200 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>can any body help how to get the last day sales of every month in one field in straight table</P><P></P><P></P><P>regards</P><P>Mahesh </P></BODY></HTML> Thu, 02 Jan 2014 14:30:37 GMT https://community.qlik.com/t5/QlikView/Month-end-data-in-straight-table/m-p/544701#M1125200 2014-01-02T14:30:37Z Re: Month end data in straight table https://community.qlik.com/t5/QlikView/Month-end-data-in-straight-table/m-p/544702#M1125201 <HTML><HEAD></HEAD><BODY><P>Flagging the month end date in the script using the MonthEnd function and a simple set analysis expression in the straight table will perhaps produce the results you are looking for. </P><P></P><P><STRONG>Script </STRONG><STRONG>Example</STRONG></P><P>IF(YourDate = MonthEnd(YourDate),1,0) as MonthEndFlag</P><P></P><P><STRONG>Month End Sales Field</STRONG></P><P>=SUM({$&lt;MonthEndFlag={1}&gt;}SalesAmount)</P></BODY></HTML> Thu, 02 Jan 2014 16:59:34 GMT https://community.qlik.com/t5/QlikView/Month-end-data-in-straight-table/m-p/544702#M1125201 2014-01-02T16:59:34Z Re: Month end data in straight table https://community.qlik.com/t5/QlikView/Month-end-data-in-straight-table/m-p/544703#M1125202 <HTML><HEAD></HEAD><BODY><P>Let vMend = MonthEnd(Today()) and add based on the flag.</P></BODY></HTML> Thu, 02 Jan 2014 17:29:04 GMT https://community.qlik.com/t5/QlikView/Month-end-data-in-straight-table/m-p/544703#M1125202 2014-01-02T17:29:04Z