topic Re: Calculate totals in QlikView

Calculate totals

CSmith — Mon, 26 Jan 2026 16:26:21 GMT

I am trying to calculate and display the totals for the 'Not Sold' and 'Sales' columns the same as the 'Total Vol' column in the Total column at the bottom of the report.

Re: Calculate totals

MayilVahanan — Wed, 24 Feb 2021 01:52:55 GMT

HI @CSmith

Can you try with this option in expression tab.

Re: Calculate totals

CSmith — Wed, 24 Feb 2021 14:09:38 GMT

I am unable reply in the community. But that total mode option is greyed out for me because I am using a pivot table not a straight table. Is there a way to put some code in the expression that will allow the calculation using a pivot table?
Thank you

Re: Calculate totals

MayilVahanan — Thu, 25 Feb 2021 08:44:20 GMT

HI @CSmith

For Pivot table, Try like below

=If(IsNull(RowNo()) or Rowno()=0 , urtotalexpression, uroriginalexpression)

Re: Calculate totals

CSmith — Thu, 25 Feb 2021 12:59:38 GMT

Thank you!!!!! That worked perfectly!!!!!