topic Re: Calculate Previous Record in QlikView https://community.qlik.com/t5/QlikView/Calculate-Previous-Record/m-p/531529#M481407 <HTML><HEAD></HEAD><BODY><P>No idea what you actually want, but one of these probably gives the result you want.</P><P></P><P>Total per customer: sum(total &lt;Customer&gt; Reading)</P><P>Total per month: sum(total &lt;Month&gt; Reading)</P><P>Total per meter: sum(total &lt;MeterNo&gt; Reading)</P><P>Total per customer per meter: sum(total &lt;Customer, MeterNo&gt; Reading)</P><P>Total per customer per month: sum(total &lt;Customer, Month&gt; Reading)</P><P>Total per meter per month: sum(total &lt;MeterNo,Month&gt; Reading)</P><P></P><P>See attached example</P></BODY></HTML> Wed, 09 Oct 2013 08:33:07 GMT Gysbert_Wassenaar 2013-10-09T08:33:07Z Calculate Previous Record https://community.qlik.com/t5/QlikView/Calculate-Previous-Record/m-p/531527#M481405 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>We have following data</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Customer</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">MeterNo</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Month</TH><TD>Reading</TD></TR><TR><TD style="padding: 2px;">Customer A</TD><TD style="padding: 2px;">Meter1</TD><TD style="padding: 2px;">Jan-13</TD><TD style="padding: 2px;">1521</TD></TR><TR><TD style="padding: 2px;">Customer A</TD><TD style="padding: 2px;">Meter1</TD><TD style="padding: 2px;">Feb-13</TD><TD style="padding: 2px;">1820</TD></TR><TR><TD>Customer A</TD><TD>Meter1</TD><TD>Mar-13</TD><TD>1989</TD></TR><TR><TD>Customer A</TD><TD>Meter2</TD><TD>Jan-13</TD><TD>32164</TD></TR><TR><TD>Customer A</TD><TD>Meter2</TD><TD>Feb-13</TD><TD>32456</TD></TR><TR><TD>CustomerB</TD><TD>Meter1</TD><TD>Jan-13</TD><TD>4454</TD></TR><TR><TD>CustomerB</TD><TD>Meter1</TD><TD>Feb-13</TD><TD>4485</TD></TR><TR><TD>CustomerB</TD><TD>Meter1</TD><TD>Mar-13</TD><TD>4565</TD></TR></TBODY></TABLE><P></P><P>we want to calculate total consumed units of the month Customer and meter wise</P><P></P><P>Any help..?</P></BODY></HTML> Wed, 09 Oct 2013 08:12:58 GMT https://community.qlik.com/t5/QlikView/Calculate-Previous-Record/m-p/531527#M481405 2013-10-09T08:12:58Z Re: Calculate Previous Record https://community.qlik.com/t5/QlikView/Calculate-Previous-Record/m-p/531528#M481406 <HTML><HEAD></HEAD><BODY><P>Put it in Pivot table</P></BODY></HTML> Wed, 09 Oct 2013 08:24:43 GMT https://community.qlik.com/t5/QlikView/Calculate-Previous-Record/m-p/531528#M481406 saumyashah90 2013-10-09T08:24:43Z Re: Calculate Previous Record https://community.qlik.com/t5/QlikView/Calculate-Previous-Record/m-p/531529#M481407 <HTML><HEAD></HEAD><BODY><P>No idea what you actually want, but one of these probably gives the result you want.</P><P></P><P>Total per customer: sum(total &lt;Customer&gt; Reading)</P><P>Total per month: sum(total &lt;Month&gt; Reading)</P><P>Total per meter: sum(total &lt;MeterNo&gt; Reading)</P><P>Total per customer per meter: sum(total &lt;Customer, MeterNo&gt; Reading)</P><P>Total per customer per month: sum(total &lt;Customer, Month&gt; Reading)</P><P>Total per meter per month: sum(total &lt;MeterNo,Month&gt; Reading)</P><P></P><P>See attached example</P></BODY></HTML> Wed, 09 Oct 2013 08:33:07 GMT https://community.qlik.com/t5/QlikView/Calculate-Previous-Record/m-p/531529#M481407 Gysbert_Wassenaar 2013-10-09T08:33:07Z Re: Calculate Previous Record https://community.qlik.com/t5/QlikView/Calculate-Previous-Record/m-p/531530#M481408 <HTML><HEAD></HEAD><BODY><P>What do you mean by previous in your title .</P><P>plz explain .</P></BODY></HTML> Wed, 09 Oct 2013 08:35:12 GMT https://community.qlik.com/t5/QlikView/Calculate-Previous-Record/m-p/531530#M481408 sujeetsingh 2013-10-09T08:35:12Z Re: Calculate Previous Record https://community.qlik.com/t5/QlikView/Calculate-Previous-Record/m-p/531531#M481409 <HTML><HEAD></HEAD><BODY><P>Thanks all.</P><P></P><P></P><P>But i solve this to my self by Previous function in script.</P></BODY></HTML> Wed, 09 Oct 2013 09:51:50 GMT https://community.qlik.com/t5/QlikView/Calculate-Previous-Record/m-p/531531#M481409 2013-10-09T09:51:50Z