topic Re: Trail Balance in QlikView

Trail Balance

upaliwije — Fri, 14 Apr 2017 05:53:38 GMT

Hi My Friends

I want your advice. I have created a trial balance in QV document in a Pivot table. But I can get the grad total of Debit and Credit Columns. Kindly see may attached QV doc and advise me pls

Re: Trail Balance

Anil_Babu_Samineni — Fri, 14 Apr 2017 06:04:14 GMT

Like this?

Re: Trail Balance

rahulpawarb — Fri, 14 Apr 2017 06:05:46 GMT

Hello Upali,

Have you tried Show Partial Sum option available on Presentation tab?

Regards!

Rahul

Re: Trail Balance

upaliwije — Fri, 14 Apr 2017 06:10:41 GMT

I have tried it

Re: Trail Balance

upaliwije — Fri, 14 Apr 2017 06:11:02 GMT

Yes like as you shown

Re: Trail Balance

Anil_Babu_Samineni — Fri, 14 Apr 2017 06:13:17 GMT

Why you want Pivot Table instead of Straight table. Change it to Straight table and then use Sum of rows radio button

Re: Trail Balance

MK_QSL — Fri, 14 Apr 2017 06:17:21 GMT

May be because there are not groups between CODE and GL_DESCRIPTION. It's one to one..

Try Straight Table and use below expressions

SUM(Aggr(IF(SUM(DEBIT)-SUM(CREDIT)>0,SUM(DEBIT)-SUM(CREDIT),0),CODE,GL_DESCRIPTION))

and

SUM(Aggr(IF(SUM(CREDIT)-SUM(DEBIT)>0,SUM(CREDIT)-SUM(DEBIT),0),CODE,GL_DESCRIPTION))

Re: Trail Balance

upaliwije — Fri, 14 Apr 2017 06:32:42 GMT

Thanks You answer also works . But Manish script works with Pivot table as well

Re: Trail Balance

rahulpawarb — Fri, 14 Apr 2017 06:52:14 GMT

refer

General Total Column in Pivot Table