topic Re: How to show the data until last month in QlikView https://community.qlik.com/t5/QlikView/How-to-show-the-data-until-last-month/m-p/1258816#M848143 <HTML><HEAD></HEAD><BODY><P>May be using Monthend() from where condition </P></BODY></HTML> Wed, 22 Mar 2017 10:54:27 GMT Anil_Babu_Samineni 2017-03-22T10:54:27Z How to show the data until last month https://community.qlik.com/t5/QlikView/How-to-show-the-data-until-last-month/m-p/1258815#M848142 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have a requirement to pull the data until the last day of the month.</P><P>Any idea how to do that on load script ?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-show-the-data-until-last-month/m-p/1258815#M848142 Anonymous 2020-11-25T16:16:04Z Re: How to show the data until last month https://community.qlik.com/t5/QlikView/How-to-show-the-data-until-last-month/m-p/1258816#M848143 <HTML><HEAD></HEAD><BODY><P>May be using Monthend() from where condition </P></BODY></HTML> Wed, 22 Mar 2017 10:54:27 GMT https://community.qlik.com/t5/QlikView/How-to-show-the-data-until-last-month/m-p/1258816#M848143 Anil_Babu_Samineni 2017-03-22T10:54:27Z Re: How to show the data until last month https://community.qlik.com/t5/QlikView/How-to-show-the-data-until-last-month/m-p/1258817#M848144 <HTML><HEAD></HEAD><BODY><P>you can either do </P><P>Year(Datefield) &lt;= Year(Today()) AND <SPAN style="font-size: 13.3333px;">Datefield</SPAN>&lt;= monthend(today()-day(today()))</P><P></P><P>or simply</P><P><SPAN style="font-size: 13.3333px;">Year(Datefield) &lt;= Year(Today()) AND</SPAN> Month(<SPAN style="font-size: 13.3333px;">Datefield</SPAN>) &lt;= Month(Today())</P></BODY></HTML> Wed, 22 Mar 2017 11:10:06 GMT https://community.qlik.com/t5/QlikView/How-to-show-the-data-until-last-month/m-p/1258817#M848144 vinieme12 2017-03-22T11:10:06Z