Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Qlik Sense Pivot Table Totals

I would like to total multiple columns under a dimension and would like to know if it's possible how to do it.

Example: Company 1 total should only include  EqAmount & LoanAmount for Company 1,

                    Company 2 total should only include EqAmount & LoanAmount for Company 2

Thanks in advance,

Pivot.png

4 Replies
Highlighted
Creator
Creator

Have you tried:

Sum(EqAmount) + Sum(LoanAmount)

 

In your Total column?

Highlighted
Contributor III
Contributor III

how do you distinguish between what is Company 1  & what is Company 2 

Highlighted
Creator
Creator

You don't have to because they are dimensions (if they are), your table will distinguish it by itself

Highlighted
Creator II
Creator II

try this 
company 1
Sum({< CompanyDesc ={'Campany 1'} >} EqAmount) + Sum({< CompanyDesc ={'Campany 1'} >}LoanAmount)

company 2
Sum({< CompanyDesc ={'Campany 2'} >} EqAmount) + Sum({< CompanyDesc ={'Campany 2'} >}LoanAmount)