Tables in Qlikview

[rassanbekov]

Hello, guys!

Could you please help to create a table in Qlikview from two dimensions:

I have the following input data:

Account name	Debit account	Debit amount	Credit account	Credit amount
Cash	1010	100	1250	500
Receivables	1210	200	1020	600
Payables	3310	300	1010	800

I need to create same in Qlik format table.

The issue is that Debit amounts should be summed by debit account and credit amount shoud be summed by credit accounts.

Kind regards,

Ruslan

[PrashantSangle]

sum([Debit account]) + sum([Debit amount])

can explain in details??

Regards

[neha_shirsath]

Hi Ruslan,

Could you please provide some sample data, that will be more helpful.

Thanks ,

Neha

[effinty2112]

Hi Ruslan,

Maybe:

Data:

LOAD [Account name],

'Debit' as [Account Type],

     [Debit account] as Account,

     [Debit amount] as Amount

FROM

[https://community.qlik.com/thread/268129]

(html, codepage is 1252, embedded labels, table is @1);

LOAD [Account name],

'Credit' as [Account Type],

     [Credit account] as Account,

     [Credit amount] as Amount

FROM

[https://community.qlik.com/thread/268129]

(html, codepage is 1252, embedded labels, table is @1);

Giving:

Account name	Account Type	Account	Amount
Cash	Credit	1250	500
Cash	Debit	1010	100
Payables	Credit	1010	800
Payables	Debit	3310	300
Receivables	Credit	1020	600
Receivables	Debit	1210	200

Cheers

Andrew

[arvind_patil]

Hi Ruslan,

I think  you need to use Aggr function to achieve this.

Aggr(sum([Debit Amount]),debit account) ,

Aggr(sum([credit amount]),CreditAccount)

Thanks,

Arvind Patil

[rassanbekov]

It is close, but I need same representation of input data in output.

[rassanbekov]

I need to create in Qlik same as I showed in input file

[PrashantSangle]

Can you provide sample data in excel which is your input file and required output also.

Regards,

[Kushal_Chawda]

did not get this. Can you please show us what output you need?