If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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,
Have you tried:
Sum(EqAmount) + Sum(LoanAmount)
In your Total column?
how do you distinguish between what is Company 1 & what is Company 2
You don't have to because they are dimensions (if they are), your table will distinguish it by itself
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)