I have a table which contains accounting notes, whith the following fields: CreditAccount, DebitAccount, CreditAmount, CreditAmount and I need a report that can show the credit and debit amount for any account. I need to make only one dimension based on CreditAccount and DebitAccound and it must be selectable.
As Andrew said your output (For this example) would be as he has put. Is that what you intended?
1 way of doing this would be to create 2 tables in qlikview based on the data that you have i.e. load credit account and credit amount in 1 table and debit account and debit amount in the second table.
The you could create a link between Credit Account and Debit account as "Account". I have represented it inline in the attached app.