topic Re: How limit loading data in script in QlikView https://community.qlik.com/t5/QlikView/How-limit-loading-data-in-script/m-p/1395434#M612939 <HTML><HEAD></HEAD><BODY><P>Try WHERE MonthStart(DATA) = MonthStart(Today(),-1)</P></BODY></HTML> Fri, 22 Sep 2017 08:01:35 GMT Gysbert_Wassenaar 2017-09-22T08:01:35Z How limit loading data in script https://community.qlik.com/t5/QlikView/How-limit-loading-data-in-script/m-p/1395433#M612937 <HTML><HEAD></HEAD><BODY><P>Hi, i need to limit data loading <STRONG>only for current year</STRONG> on the previous month, for instance today I need only August data</P><P>I've tried to set a where condition:</P><P>where NUM(month(DATA)) &lt;= NUM(month(today())-1); but this set on 8 (August) data also in 2016, 2015, ecc.</P><P>Can you help me?</P></BODY></HTML> Fri, 22 Sep 2017 07:55:56 GMT https://community.qlik.com/t5/QlikView/How-limit-loading-data-in-script/m-p/1395433#M612937 canmarroig 2017-09-22T07:55:56Z Re: How limit loading data in script https://community.qlik.com/t5/QlikView/How-limit-loading-data-in-script/m-p/1395434#M612939 <HTML><HEAD></HEAD><BODY><P>Try WHERE MonthStart(DATA) = MonthStart(Today(),-1)</P></BODY></HTML> Fri, 22 Sep 2017 08:01:35 GMT https://community.qlik.com/t5/QlikView/How-limit-loading-data-in-script/m-p/1395434#M612939 Gysbert_Wassenaar 2017-09-22T08:01:35Z Re: How limit loading data in script https://community.qlik.com/t5/QlikView/How-limit-loading-data-in-script/m-p/1395435#M612940 <HTML><HEAD></HEAD><BODY><P>As i understand from query is ,</P><P></P><P>You need full data for previous years but for current year, you want only current month data.</P><P>Is this the case?</P></BODY></HTML> Fri, 22 Sep 2017 08:18:19 GMT https://community.qlik.com/t5/QlikView/How-limit-loading-data-in-script/m-p/1395435#M612940 balar025 2017-09-22T08:18:19Z