topic Help on cumulative calculation in record looping in QlikView https://community.qlik.com/t5/QlikView/Help-on-cumulative-calculation-in-record-looping/m-p/461420#M490871 <HTML><HEAD></HEAD><BODY><P>Dear pals,</P><P></P><P>I need your help to give me some idea on how to solve the below issue.</P><P></P><P>Current data that I have </P><P></P><P><IMG __jive_id="22881" class="jive-image-thumbnail jive-image" height="374" onclick="" alt="Capture.JPG" src="https://community.qlik.com/legacyfs/online/22881_Capture.JPG" width="552" /></P><P>As you can see the above, my raw data will look like</P><P><IMG __jive_id="22882" class="jive-image-thumbnail jive-image" height="217" onclick="" alt="Capture2.JPG" src="https://community.qlik.com/legacyfs/online/22882_Capture2.JPG" width="498" /> </P><P>What I am trying to achieve is to determine the status of each Schedule Delivery Date, because the total quantity is spread out to several schedule date with schedule quantity.</P><P>The total delivery itself also refered to the item no, thus the logic is to sort the schedule delivery date, get the Total Quantity of the item - Schedule Delivery Quantity per Schedule Date (cumulative calculation).</P><P></P><P>Please help on how I can achieve this.</P><P></P><P>Thank you.</P></BODY></HTML> Wed, 03 Oct 2012 09:56:43 GMT 2012-10-03T09:56:43Z Help on cumulative calculation in record looping https://community.qlik.com/t5/QlikView/Help-on-cumulative-calculation-in-record-looping/m-p/461420#M490871 <HTML><HEAD></HEAD><BODY><P>Dear pals,</P><P></P><P>I need your help to give me some idea on how to solve the below issue.</P><P></P><P>Current data that I have </P><P></P><P><IMG __jive_id="22881" class="jive-image-thumbnail jive-image" height="374" onclick="" alt="Capture.JPG" src="https://community.qlik.com/legacyfs/online/22881_Capture.JPG" width="552" /></P><P>As you can see the above, my raw data will look like</P><P><IMG __jive_id="22882" class="jive-image-thumbnail jive-image" height="217" onclick="" alt="Capture2.JPG" src="https://community.qlik.com/legacyfs/online/22882_Capture2.JPG" width="498" /> </P><P>What I am trying to achieve is to determine the status of each Schedule Delivery Date, because the total quantity is spread out to several schedule date with schedule quantity.</P><P>The total delivery itself also refered to the item no, thus the logic is to sort the schedule delivery date, get the Total Quantity of the item - Schedule Delivery Quantity per Schedule Date (cumulative calculation).</P><P></P><P>Please help on how I can achieve this.</P><P></P><P>Thank you.</P></BODY></HTML> Wed, 03 Oct 2012 09:56:43 GMT https://community.qlik.com/t5/QlikView/Help-on-cumulative-calculation-in-record-looping/m-p/461420#M490871 2012-10-03T09:56:43Z