topic How to extract and show the last value per month. in QlikView https://community.qlik.com/t5/QlikView/How-to-extract-and-show-the-last-value-per-month/m-p/96102#M457624 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Could you please help me to solve this small problem?</P><P></P><P>How to create monthly aggregation and take the "Ballance ammount" for the last day of the month.</P><P>Please be aware that there are more than one transaction on the last day so then the load order should be consider.</P><P></P><P>My guessing is that I have to run this at the script load phase, and use previous function when date will change to the next then I can call the last value... but still not sure how it make happen or is it the right way to do it.</P><P></P><P>My idea: if(month(Previous(Date))&gt;month(Date),Ballance,0) as monthly_result</P><P></P><P>Example:</P><P><IMG __jive_id="214155" alt="QlikForum task 1.jpg" class="jive-image image-1" src="/legacyfs/online/214155_QlikForum task 1.jpg" style="height: auto;" /></P></BODY></HTML> Fri, 21 Sep 2018 09:45:39 GMT waszcma1 2018-09-21T09:45:39Z How to extract and show the last value per month. https://community.qlik.com/t5/QlikView/How-to-extract-and-show-the-last-value-per-month/m-p/96102#M457624 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Could you please help me to solve this small problem?</P><P></P><P>How to create monthly aggregation and take the "Ballance ammount" for the last day of the month.</P><P>Please be aware that there are more than one transaction on the last day so then the load order should be consider.</P><P></P><P>My guessing is that I have to run this at the script load phase, and use previous function when date will change to the next then I can call the last value... but still not sure how it make happen or is it the right way to do it.</P><P></P><P>My idea: if(month(Previous(Date))&gt;month(Date),Ballance,0) as monthly_result</P><P></P><P>Example:</P><P><IMG __jive_id="214155" alt="QlikForum task 1.jpg" class="jive-image image-1" src="/legacyfs/online/214155_QlikForum task 1.jpg" style="height: auto;" /></P></BODY></HTML> Fri, 21 Sep 2018 09:45:39 GMT https://community.qlik.com/t5/QlikView/How-to-extract-and-show-the-last-value-per-month/m-p/96102#M457624 waszcma1 2018-09-21T09:45:39Z