Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
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

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

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

View solution in original post

upaliwije
Creator II
Creator II
Author

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

rahulpawarb
Specialist III
Specialist III