topic Re: Tables in Qlikview in QlikView

Tables in Qlikview

rassanbekov — Wed, 19 Jul 2017 07:00:39 GMT

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

Re: Tables in Qlikview

PrashantSangle — Wed, 19 Jul 2017 07:07:24 GMT

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

can explain in details??

Regards

Re: Tables in Qlikview

neha_shirsath — Wed, 19 Jul 2017 07:07:57 GMT

Hi Ruslan,

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

Thanks ,

Neha

Re: Tables in Qlikview

effinty2112 — Wed, 19 Jul 2017 07:14:54 GMT

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

Re: Tables in Qlikview

arvind_patil — Wed, 19 Jul 2017 07:20:02 GMT

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

Re: Tables in Qlikview

rassanbekov — Wed, 19 Jul 2017 07:20:24 GMT

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

Re: Tables in Qlikview

rassanbekov — Wed, 19 Jul 2017 07:20:51 GMT

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

Re: Tables in Qlikview

PrashantSangle — Wed, 19 Jul 2017 07:22:09 GMT

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

Regards,

Re: Tables in Qlikview

Kushal_Chawda — Wed, 19 Jul 2017 07:32:25 GMT

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