topic How to run accumulated calculation in load script with 2 dimensions? in QlikView https://community.qlik.com/t5/QlikView/How-to-run-accumulated-calculation-in-load-script-with-2/m-p/523253#M195522 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10.0pt;">I’m using this for accumulating 1 dimension (Date) ,</SPAN></P><P><SPAN style="font-size: 10.0pt;">test1:</SPAN></P><P><SPAN style="font-size: 10.0pt;">load </SPAN></P><P><SPAN style="font-size: 10.0pt;">CalendarDate,</SPAN></P><P><SPAN style="font-size: 10.0pt;">country,<BR /></SPAN></P><P><SPAN style="color: black;">DailySales</SPAN><SPAN style="font-size: 10.0pt;">,</SPAN></P><P><SPAN style="font-size: 10.0pt;">If(RowNo() = 1, </SPAN><SPAN style="color: black;">DailySales</SPAN><SPAN style="font-size: 10.0pt;">, Peek('AccumulatedSales') + </SPAN><SPAN style="color: black;">DailySales</SPAN><SPAN style="font-size: 10.0pt;">) AS AccumulatedSales</SPAN></P><P><SPAN style="font-size: 10.0pt;">resident test;</SPAN></P><P></P><P>you can see that the accumulation is made for the date excluding the country. (you see below only sample of the data)</P><P></P><P>how can I adjust it to 2 dimensions?</P><P></P><P>Thanks.</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 444px;"><TBODY><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="96"><P><SPAN style="color: black;">Date</SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="160"><P><SPAN style="color: black;">country</SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P><SPAN style="color: black;">DailySales</SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="124"><P><SPAN style="color: black;">AccumulatedSales</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="96"><P><SPAN style="color: black;">7/24/2013</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="160"><P><SPAN style="color: black;">Afghanistan - AF</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P align="right" style="text-align: right;"><SPAN style="color: black;">7</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="124"><P align="right" style="text-align: right;"><SPAN style="color: black;">34794</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="96"><P><SPAN style="color: black;">7/24/2013</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="160"><P><SPAN style="color: black;">Albania - AL</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P align="right" style="text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="124"><P align="right" style="text-align: right;"><SPAN style="color: black;">34824</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="96"><P><SPAN style="color: black;">7/23/2013</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="160"><P><SPAN style="color: black;">Afghanistan - AF</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P align="right" style="text-align: right;"><SPAN style="color: black;">0</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="124"><P align="right" style="text-align: right;"><SPAN style="color: black;">34787</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="96"><P><SPAN style="color: black;">7/23/2013</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="160"><P><SPAN style="color: black;">Albania - AL</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P align="right" style="text-align: right;"><SPAN style="color: black;">3</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="124"><P align="right" style="text-align: right;"><SPAN style="color: black;">34823</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="96"><P><SPAN style="color: black;">7/22/2013</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="160"><P><SPAN style="color: black;">Afghanistan - AF</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P align="right" style="text-align: right;"><SPAN style="color: black;">5</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="124"><P align="right" style="text-align: right;"><SPAN style="color: black;">34787</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="96"><P><SPAN style="color: black;">7/22/2013</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="160"><P><SPAN style="color: black;">Albania - AL</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P align="right" style="text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="124"><P align="right" style="text-align: right;"><SPAN style="color: black;">34820</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="96"><P><SPAN style="color: black;">7/21/2013</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="160"><P><SPAN style="color: black;">Afghanistan - AF</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P align="right" style="text-align: right;"><SPAN style="color: black;">9</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="124"><P align="right" style="text-align: right;"><SPAN style="color: black;">34782</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="96"><P><SPAN style="color: black;">7/21/2013</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="160"><P><SPAN style="color: black;">Albania - AL</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P align="right" style="text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="124"><P align="right" style="text-align: right;"><SPAN style="color: black;">34819</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="96"><P><SPAN style="color: black;">7/20/2013</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="160"><P><SPAN style="color: black;">Afghanistan - AF</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P align="right" style="text-align: right;"><SPAN style="color: black;">10</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="124"><P align="right" style="text-align: right;"><SPAN style="color: black;">34773</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="96"><P><SPAN style="color: black;">7/20/2013</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="160"><P><SPAN style="color: black;">Albania - AL</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P align="right" style="text-align: right;"><SPAN style="color: black;">0</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="124"><P align="right" style="text-align: right;"><SPAN style="color: black;">34818</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="96"><P><SPAN style="color: black;">7/19/2013</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="160"><P><SPAN style="color: black;">Afghanistan - AF</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P align="right" style="text-align: right;"><SPAN style="color: black;">10</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="124"><P align="right" style="text-align: right;"><SPAN style="color: black;">34763</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="96"><P><SPAN style="color: black;">7/19/2013</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="160"><P><SPAN style="color: black;">Albania - AL</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P align="right" style="text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="124"><P align="right" style="text-align: right;"><SPAN style="color: black;">34818</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="96"><P><SPAN style="color: black;">7/18/2013</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="160"><P><SPAN style="color: black;">Afghanistan - AF</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P align="right" style="text-align: right;"><SPAN style="color: black;">7</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="124"><P align="right" style="text-align: right;"><SPAN style="color: black;">34753</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="96"><P><SPAN style="color: black;">7/18/2013</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="160"><P><SPAN style="color: black;">Albania - AL</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P align="right" style="text-align: right;"><SPAN style="color: black;">0</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="124"><P align="right" style="text-align: right;"><SPAN style="color: black;">34817</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="96"><P><SPAN style="color: black;">7/17/2013</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="160"><P><SPAN style="color: black;">Afghanistan - AF</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P align="right" style="text-align: right;"><SPAN style="color: black;">13</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="124"><P align="right" style="text-align: right;"><SPAN style="color: black;">34746</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="96"><P><SPAN style="color: black;">7/17/2013</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="160"><P><SPAN style="color: black;">Albania - AL</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P align="right" style="text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="124"><P align="right" style="text-align: right;"><SPAN style="color: black;">34817</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="96"><P><SPAN style="color: black;">7/16/2013</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="160"><P><SPAN style="color: black;">Afghanistan - AF</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P align="right" style="text-align: right;"><SPAN style="color: black;">17</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="124"><P align="right" style="text-align: right;"><SPAN style="color: black;">34733</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="96"><P><SPAN style="color: black;">7/16/2013</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="160"><P><SPAN style="color: black;">Albania - AL</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P align="right" style="text-align: right;"><SPAN style="color: black;">2</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="124"><P align="right" style="text-align: right;"><SPAN style="color: black;">34816</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="96"><P><SPAN style="color: black;">7/15/2013</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="160"><P><SPAN style="color: black;">Afghanistan - AF</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P align="right" style="text-align: right;"><SPAN style="color: black;">54</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="124"><P align="right" style="text-align: right;"><SPAN style="color: black;">34716</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="96"><P><SPAN style="color: black;">7/15/2013</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="160"><P><SPAN style="color: black;">Albania - AL</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P align="right" style="text-align: right;"><SPAN style="color: black;">20</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="124"><P align="right" style="text-align: right;"><SPAN style="color: black;">34814</SPAN></P></TD></TR></TBODY></TABLE></BODY></HTML> Thu, 25 Jul 2013 08:57:44 GMT 2013-07-25T08:57:44Z How to run accumulated calculation in load script with 2 dimensions? https://community.qlik.com/t5/QlikView/How-to-run-accumulated-calculation-in-load-script-with-2/m-p/523253#M195522 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10.0pt;">I’m using this for accumulating 1 dimension (Date) ,</SPAN></P><P><SPAN style="font-size: 10.0pt;">test1:</SPAN></P><P><SPAN style="font-size: 10.0pt;">load </SPAN></P><P><SPAN style="font-size: 10.0pt;">CalendarDate,</SPAN></P><P><SPAN style="font-size: 10.0pt;">country,<BR /></SPAN></P><P><SPAN style="color: black;">DailySales</SPAN><SPAN style="font-size: 10.0pt;">,</SPAN></P><P><SPAN style="font-size: 10.0pt;">If(RowNo() = 1, </SPAN><SPAN style="color: black;">DailySales</SPAN><SPAN style="font-size: 10.0pt;">, Peek('AccumulatedSales') + </SPAN><SPAN style="color: black;">DailySales</SPAN><SPAN style="font-size: 10.0pt;">) AS AccumulatedSales</SPAN></P><P><SPAN style="font-size: 10.0pt;">resident test;</SPAN></P><P></P><P>you can see that the accumulation is made for the date excluding the country. (you see below only sample of the data)</P><P></P><P>how can I adjust it to 2 dimensions?</P><P></P><P>Thanks.</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 444px;"><TBODY><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="96"><P><SPAN style="color: black;">Date</SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="160"><P><SPAN style="color: black;">country</SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P><SPAN style="color: black;">DailySales</SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="124"><P><SPAN style="color: black;">AccumulatedSales</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="96"><P><SPAN style="color: black;">7/24/2013</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="160"><P><SPAN style="color: black;">Afghanistan - AF</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P align="right" style="text-align: right;"><SPAN style="color: black;">7</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="124"><P align="right" style="text-align: right;"><SPAN style="color: black;">34794</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="96"><P><SPAN style="color: black;">7/24/2013</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="160"><P><SPAN style="color: black;">Albania - AL</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P align="right" style="text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="124"><P align="right" style="text-align: right;"><SPAN style="color: black;">34824</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="96"><P><SPAN style="color: black;">7/23/2013</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="160"><P><SPAN style="color: black;">Afghanistan - AF</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P align="right" style="text-align: right;"><SPAN style="color: black;">0</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="124"><P align="right" style="text-align: right;"><SPAN style="color: black;">34787</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="96"><P><SPAN style="color: black;">7/23/2013</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="160"><P><SPAN style="color: black;">Albania - AL</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P align="right" style="text-align: right;"><SPAN style="color: black;">3</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="124"><P align="right" style="text-align: right;"><SPAN style="color: black;">34823</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="96"><P><SPAN style="color: black;">7/22/2013</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="160"><P><SPAN style="color: black;">Afghanistan - AF</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P align="right" style="text-align: right;"><SPAN style="color: black;">5</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="124"><P align="right" style="text-align: right;"><SPAN style="color: black;">34787</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="96"><P><SPAN style="color: black;">7/22/2013</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="160"><P><SPAN style="color: black;">Albania - AL</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P align="right" style="text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="124"><P align="right" style="text-align: right;"><SPAN style="color: black;">34820</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="96"><P><SPAN style="color: black;">7/21/2013</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="160"><P><SPAN style="color: black;">Afghanistan - AF</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P align="right" style="text-align: right;"><SPAN style="color: black;">9</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="124"><P align="right" style="text-align: right;"><SPAN style="color: black;">34782</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="96"><P><SPAN style="color: black;">7/21/2013</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="160"><P><SPAN style="color: black;">Albania - AL</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P align="right" style="text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="124"><P align="right" style="text-align: right;"><SPAN style="color: black;">34819</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="96"><P><SPAN style="color: black;">7/20/2013</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="160"><P><SPAN style="color: black;">Afghanistan - AF</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P align="right" style="text-align: right;"><SPAN style="color: black;">10</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="124"><P align="right" style="text-align: right;"><SPAN style="color: black;">34773</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="96"><P><SPAN style="color: black;">7/20/2013</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="160"><P><SPAN style="color: black;">Albania - AL</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P align="right" style="text-align: right;"><SPAN style="color: black;">0</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="124"><P align="right" style="text-align: right;"><SPAN style="color: black;">34818</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="96"><P><SPAN style="color: black;">7/19/2013</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="160"><P><SPAN style="color: black;">Afghanistan - AF</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P align="right" style="text-align: right;"><SPAN style="color: black;">10</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="124"><P align="right" style="text-align: right;"><SPAN style="color: black;">34763</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="96"><P><SPAN style="color: black;">7/19/2013</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="160"><P><SPAN style="color: black;">Albania - AL</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P align="right" style="text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="124"><P align="right" style="text-align: right;"><SPAN style="color: black;">34818</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="96"><P><SPAN style="color: black;">7/18/2013</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="160"><P><SPAN style="color: black;">Afghanistan - AF</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P align="right" style="text-align: right;"><SPAN style="color: black;">7</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="124"><P align="right" style="text-align: right;"><SPAN style="color: black;">34753</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="96"><P><SPAN style="color: black;">7/18/2013</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="160"><P><SPAN style="color: black;">Albania - AL</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P align="right" style="text-align: right;"><SPAN style="color: black;">0</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="124"><P align="right" style="text-align: right;"><SPAN style="color: black;">34817</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="96"><P><SPAN style="color: black;">7/17/2013</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="160"><P><SPAN style="color: black;">Afghanistan - AF</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P align="right" style="text-align: right;"><SPAN style="color: black;">13</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="124"><P align="right" style="text-align: right;"><SPAN style="color: black;">34746</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="96"><P><SPAN style="color: black;">7/17/2013</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="160"><P><SPAN style="color: black;">Albania - AL</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P align="right" style="text-align: right;"><SPAN style="color: black;">1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="124"><P align="right" style="text-align: right;"><SPAN style="color: black;">34817</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="96"><P><SPAN style="color: black;">7/16/2013</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="160"><P><SPAN style="color: black;">Afghanistan - AF</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P align="right" style="text-align: right;"><SPAN style="color: black;">17</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="124"><P align="right" style="text-align: right;"><SPAN style="color: black;">34733</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="96"><P><SPAN style="color: black;">7/16/2013</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="160"><P><SPAN style="color: black;">Albania - AL</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P align="right" style="text-align: right;"><SPAN style="color: black;">2</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="124"><P align="right" style="text-align: right;"><SPAN style="color: black;">34816</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="96"><P><SPAN style="color: black;">7/15/2013</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="160"><P><SPAN style="color: black;">Afghanistan - AF</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P align="right" style="text-align: right;"><SPAN style="color: black;">54</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="124"><P align="right" style="text-align: right;"><SPAN style="color: black;">34716</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="96"><P><SPAN style="color: black;">7/15/2013</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="160"><P><SPAN style="color: black;">Albania - AL</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="64"><P align="right" style="text-align: right;"><SPAN style="color: black;">20</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="124"><P align="right" style="text-align: right;"><SPAN style="color: black;">34814</SPAN></P></TD></TR></TBODY></TABLE></BODY></HTML> Thu, 25 Jul 2013 08:57:44 GMT https://community.qlik.com/t5/QlikView/How-to-run-accumulated-calculation-in-load-script-with-2/m-p/523253#M195522 2013-07-25T08:57:44Z Re: How to run accumulated calculation in load script with 2 dimensions? https://community.qlik.com/t5/QlikView/How-to-run-accumulated-calculation-in-load-script-with-2/m-p/523254#M195523 <HTML><HEAD></HEAD><BODY><P>Have a look at this post: <A _jive_internal="true" class="loading" href="https://community.qlik.com/message/100042#100042" title="http://community.qlik.com/message/100042#100042">http://community.qlik.com/message/100042#100042</A></P><P>Jonathan</P></BODY></HTML> Thu, 25 Jul 2013 09:04:55 GMT https://community.qlik.com/t5/QlikView/How-to-run-accumulated-calculation-in-load-script-with-2/m-p/523254#M195523 Anonymous 2013-07-25T09:04:55Z Re: How to run accumulated calculation in load script with 2 dimensions? https://community.qlik.com/t5/QlikView/How-to-run-accumulated-calculation-in-load-script-with-2/m-p/523255#M195524 <HTML><HEAD></HEAD><BODY><P style="background-color: #ffffff; color: #737373; font-family: Arial;"><SPAN style="font-size: 10pt;">test1:</SPAN></P><P style="background-color: #ffffff; color: #737373; font-family: Arial;"><SPAN style="font-size: 10pt;">load</SPAN></P><P style="background-color: #ffffff; color: #737373; font-family: Arial;"><SPAN style="font-size: 10pt;">CalendarDate,</SPAN></P><P style="background-color: #ffffff; color: #737373; font-family: Arial;"><SPAN style="font-size: 10pt;">country,<BR /></SPAN></P><P style="background-color: #ffffff; color: #737373; font-family: Arial;"><SPAN style="color: black;">DailySales</SPAN><SPAN style="font-size: 10pt;">,</SPAN></P><P style="background-color: #ffffff; color: #737373; font-family: Arial;"><SPAN style="font-size: 10pt;">If(country&lt;&gt;previous(country), </SPAN><SPAN style="color: black;">DailySales</SPAN><SPAN style="font-size: 10pt;">, Peek('AccumulatedSales') + </SPAN><SPAN style="color: black;">DailySales</SPAN><SPAN style="font-size: 10pt;">) AS AccumulatedSales</SPAN></P><P style="background-color: #ffffff; color: #737373; font-family: Arial;"><SPAN style="font-size: 10pt;">resident test</SPAN></P><P style="background-color: #ffffff; color: #737373; font-family: Arial;"><SPAN style="font-size: 10pt;">order by country CalendarDate;</SPAN></P><P></P><P style="background-color: #ffffff; color: #737373; font-family: Arial;"><SPAN style="font-size: 10pt;">this will accumulate the sales for each country by date<BR /></SPAN></P></BODY></HTML> Thu, 25 Jul 2013 09:08:15 GMT https://community.qlik.com/t5/QlikView/How-to-run-accumulated-calculation-in-load-script-with-2/m-p/523255#M195524 lironbaram 2013-07-25T09:08:15Z Re: How to run accumulated calculation in load script with 2 dimensions? https://community.qlik.com/t5/QlikView/How-to-run-accumulated-calculation-in-load-script-with-2/m-p/523256#M195525 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt; color: #737373; font-family: Arial;">If(country<STRONG>=</STRONG>revious(country), </SPAN><SPAN style="font-family: Arial; color: black;">DailySales</SPAN><SPAN style="font-size: 10pt; color: #737373; font-family: Arial;">, Peek('AccumulatedSales') + </SPAN><SPAN style="font-family: Arial; color: black;">DailySales</SPAN><SPAN style="font-size: 10pt; color: #737373; font-family: Arial;">) AS AccumulatedSales</SPAN></P><P></P><P></P><P>thanks</P></BODY></HTML> Thu, 25 Jul 2013 11:08:08 GMT https://community.qlik.com/t5/QlikView/How-to-run-accumulated-calculation-in-load-script-with-2/m-p/523256#M195525 2013-07-25T11:08:08Z