topic Accumulating Data in the Script in QlikView https://community.qlik.com/t5/QlikView/Accumulating-Data-in-the-Script/m-p/236191#M87393 <HTML><HEAD></HEAD><BODY><P>I would like to accumulate Metric1 in Table 1 (attached) in the Load Script across the Period field for each Release. However upon doing so i would also like to set the first Period for each Release to start at 1 and then increment by 1. So for Release 2009, Period 2009-02 would become 1, Period 2009-03 would become 2 and so on. For Release 2010 Period 2010-03 would become 1, Period 2010-04 would become 2 and so on.</P><P>Can anybody suggest a way of doing this in the load script please. I have a larger / wider requirement than this so i cannot simply use the full accumulation within the Chart so this must be done in the creation of the dataset.</P><P></P><P>Regards</P><P></P><P>JH</P></BODY></HTML> Wed, 28 Jul 2010 13:56:23 GMT johnhorneramllp 2010-07-28T13:56:23Z Accumulating Data in the Script https://community.qlik.com/t5/QlikView/Accumulating-Data-in-the-Script/m-p/236191#M87393 <HTML><HEAD></HEAD><BODY><P>I would like to accumulate Metric1 in Table 1 (attached) in the Load Script across the Period field for each Release. However upon doing so i would also like to set the first Period for each Release to start at 1 and then increment by 1. So for Release 2009, Period 2009-02 would become 1, Period 2009-03 would become 2 and so on. For Release 2010 Period 2010-03 would become 1, Period 2010-04 would become 2 and so on.</P><P>Can anybody suggest a way of doing this in the load script please. I have a larger / wider requirement than this so i cannot simply use the full accumulation within the Chart so this must be done in the creation of the dataset.</P><P></P><P>Regards</P><P></P><P>JH</P></BODY></HTML> Wed, 28 Jul 2010 13:56:23 GMT https://community.qlik.com/t5/QlikView/Accumulating-Data-in-the-Script/m-p/236191#M87393 johnhorneramllp 2010-07-28T13:56:23Z