Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jjking58
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
vmoreno2605
Creator
Creator

Have you tried:

Sum(EqAmount) + Sum(LoanAmount)

 

In your Total column?

jjking58
Contributor III
Contributor III
Author

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

vmoreno2605
Creator
Creator

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

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