Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
ansonkhau
New Contributor

Sum Range of Ledger Accounts with Exclusions for Multiple Companies

Hi QlikCommunity, I am trying to calculate accounting figures for multiple companies given a range of accounts.  How can I do it in the script?

In the Ledger Transactions Table, I have:

Amount

Account Codes

Dimension T10

Dimension T3

Company

For specific accounting figures, I need to sum Amount over range of account dimensions and there is some exclusions for some companies. 

Turnover

Company AB



Ledger a/c code2834010.......31780102834010........3178010
Dim T107832100020..78321000607832100020.....7832100060
Dim T3Exclude    3KX3

How can I Group the Accounts in script with exclusions and sum the Amount to calculate turnover?

Thanks,

Anson 

1 Reply
Not applicable

Re: Sum Range of Ledger Accounts with Exclusions for Multiple Companies

what is to be included, what is to be excluded ? not very much clear to me