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
Did you mean:
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

4 Replies
Creator

Have you tried:

Sum(EqAmount) + Sum(LoanAmount)

Contributor III
Author

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

Creator

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

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)

Tags
Community Browser