https://community.qlik.com/t5/QlikView/How-to-get-VALUE-from-last-MONTH/m-p/1560530#M441264 <PRE>if(Uraian = 'FFB Nucleus',sum({&lt; YEAR={$(=max(YEAR))}, LEVEL4 = {"Inti"}, LEVEL3 = {"FFB Purchase"}, WRTTP = {"4"}, MONTH={"=$(=max({&lt;YEAR={$(=max(YEAR))}&gt;} MONTH)-1)"}&gt;}QTY1)</PRE><P>You may want to check the max(year) part . for situation like this i try to number the month in ascending order . for example lest's say i hav date from dec 2017 till today , so i will assign 1 to dec 207,&nbsp; to jan 2018 and so on . It will help when calculating previous month as well.</P> Mon, 25 Mar 2019 06:50:27 GMT pradosh_thakur 2019-03-25T06:50:27Z https://community.qlik.com/t5/QlikView/How-to-get-VALUE-from-last-MONTH/m-p/1560492#M441263 <P><STRONG>how to get VALUE from last MONTH ?</STRONG></P><P><STRONG>this is my script for current MONTH :</STRONG></P><PRE>if(Uraian = 'FFB Nucleus',sum({&lt; YEAR={$(=max(YEAR))}, LEVEL4 = {"Inti"}, LEVEL3 = {"FFB Purchase"}, WRTTP = {"4"}, MONTH={"=$(=max({&lt;YEAR={$(=max(YEAR))}&gt;} MONTH))"}&gt;}QTY1)</PRE> Sat, 16 Nov 2024 04:03:52 GMT https://community.qlik.com/t5/QlikView/How-to-get-VALUE-from-last-MONTH/m-p/1560492#M441263 rizkyramansyah 2024-11-16T04:03:52Z https://community.qlik.com/t5/QlikView/How-to-get-VALUE-from-last-MONTH/m-p/1560530#M441264 <PRE>if(Uraian = 'FFB Nucleus',sum({&lt; YEAR={$(=max(YEAR))}, LEVEL4 = {"Inti"}, LEVEL3 = {"FFB Purchase"}, WRTTP = {"4"}, MONTH={"=$(=max({&lt;YEAR={$(=max(YEAR))}&gt;} MONTH)-1)"}&gt;}QTY1)</PRE><P>You may want to check the max(year) part . for situation like this i try to number the month in ascending order . for example lest's say i hav date from dec 2017 till today , so i will assign 1 to dec 207,&nbsp; to jan 2018 and so on . It will help when calculating previous month as well.</P> Mon, 25 Mar 2019 06:50:27 GMT https://community.qlik.com/t5/QlikView/How-to-get-VALUE-from-last-MONTH/m-p/1560530#M441264 pradosh_thakur 2019-03-25T06:50:27Z