Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
upaliwije
Creator II
Creator II

Trail Balance

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

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

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))

View solution in original post

8 Replies
Anil_Babu_Samineni

Like this?

Capture.PNG

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
rahulpawarb
Specialist III
Specialist III

Hello Upali,

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

Regards!

Rahul

upaliwije
Creator II
Creator II
Author

I have tried it

upaliwije
Creator II
Creator II
Author

Yes like as you shown

Anil_Babu_Samineni

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

Capture.PNG

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
MK_QSL
MVP
MVP

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))

upaliwije
Creator II
Creator II
Author

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