topic Sum Range of Ledger Accounts with Exclusions for Multiple Companies in QlikView https://community.qlik.com/t5/QlikView/Sum-Range-of-Ledger-Accounts-with-Exclusions-for-Multiple/m-p/393985#M146911 <HTML><HEAD></HEAD><BODY><P>Hi QlikCommunity, I am trying to calculate accounting figures for multiple companies given a range of accounts.&nbsp; How can I do it in the script?</P><P></P><P>In the Ledger Transactions Table, I have:</P><P>Amount</P><P>Account Codes</P><P>Dimension T10</P><P>Dimension T3</P><P>Company </P><P></P><P>For specific accounting figures, I need to sum Amount over range of account dimensions and there is some exclusions for some companies.&nbsp; </P><P></P><P>Turnover </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 549px;"><TBODY><TR><TD class="xl64" height="15" width="119">Company </TD><TD class="xl65" width="215">A</TD><TD class="xl65" width="215">B</TD></TR><TR><TD class="xl64" height="15"><BR /></TD><TD class="xl66"><BR /></TD><TD class="xl66"><BR /></TD></TR><TR><TD class="xl64" height="15">Ledger a/c code</TD><TD class="xl64">2834010.......3178010</TD><TD class="xl64">2834010........3178010</TD></TR><TR><TD class="xl64" height="15">Dim T10</TD><TD class="xl64">7832100020..7832100060</TD><TD class="xl64">7832100020.....7832100060</TD></TR><TR><TD class="xl64" height="15">Dim T3</TD><TD class="xl64">Exclude&nbsp;&nbsp;&nbsp; 3KX3</TD><TD><BR /></TD></TR></TBODY></TABLE><P></P><P>How can I Group the Accounts in script with exclusions and sum the Amount to calculate turnover? </P><P></P><P>Thanks,</P><P></P><P>Anson&nbsp; </P></BODY></HTML> Fri, 02 Nov 2012 02:04:47 GMT ansonkhau 2012-11-02T02:04:47Z Sum Range of Ledger Accounts with Exclusions for Multiple Companies https://community.qlik.com/t5/QlikView/Sum-Range-of-Ledger-Accounts-with-Exclusions-for-Multiple/m-p/393985#M146911 <HTML><HEAD></HEAD><BODY><P>Hi QlikCommunity, I am trying to calculate accounting figures for multiple companies given a range of accounts.&nbsp; How can I do it in the script?</P><P></P><P>In the Ledger Transactions Table, I have:</P><P>Amount</P><P>Account Codes</P><P>Dimension T10</P><P>Dimension T3</P><P>Company </P><P></P><P>For specific accounting figures, I need to sum Amount over range of account dimensions and there is some exclusions for some companies.&nbsp; </P><P></P><P>Turnover </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 549px;"><TBODY><TR><TD class="xl64" height="15" width="119">Company </TD><TD class="xl65" width="215">A</TD><TD class="xl65" width="215">B</TD></TR><TR><TD class="xl64" height="15"><BR /></TD><TD class="xl66"><BR /></TD><TD class="xl66"><BR /></TD></TR><TR><TD class="xl64" height="15">Ledger a/c code</TD><TD class="xl64">2834010.......3178010</TD><TD class="xl64">2834010........3178010</TD></TR><TR><TD class="xl64" height="15">Dim T10</TD><TD class="xl64">7832100020..7832100060</TD><TD class="xl64">7832100020.....7832100060</TD></TR><TR><TD class="xl64" height="15">Dim T3</TD><TD class="xl64">Exclude&nbsp;&nbsp;&nbsp; 3KX3</TD><TD><BR /></TD></TR></TBODY></TABLE><P></P><P>How can I Group the Accounts in script with exclusions and sum the Amount to calculate turnover? </P><P></P><P>Thanks,</P><P></P><P>Anson&nbsp; </P></BODY></HTML> Fri, 02 Nov 2012 02:04:47 GMT https://community.qlik.com/t5/QlikView/Sum-Range-of-Ledger-Accounts-with-Exclusions-for-Multiple/m-p/393985#M146911 ansonkhau 2012-11-02T02:04:47Z Re: Sum Range of Ledger Accounts with Exclusions for Multiple Companies https://community.qlik.com/t5/QlikView/Sum-Range-of-Ledger-Accounts-with-Exclusions-for-Multiple/m-p/393986#M146912 <HTML><HEAD></HEAD><BODY><P>what is to be included, what is to be excluded ? not very much clear to me</P></BODY></HTML> Fri, 02 Nov 2012 07:00:33 GMT https://community.qlik.com/t5/QlikView/Sum-Range-of-Ledger-Accounts-with-Exclusions-for-Multiple/m-p/393986#M146912 2012-11-02T07:00:33Z