Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
brijesh1991
Contributor III

Pivot Table total not proper

Hi all,


I had a pivot table like this containing two dimentions Region and Campain and one expression: count(case): As shown in attached image: I had take horizonal total by checking show partial sum for Campain Dimention. But this total is not coming perfect. For example: for Guj, it shoud come 30, but in my application it's not 30. all the '?' indicates invalid total.
Is this a pivot table bug or can you please help me out??
Best Regards, Brijesh

1 Solution

Accepted Solutions
brijesh1991
Contributor III

Re: Pivot Table total not proper

Hi All, I detected the problem. By default, Pivot table has Total Mode: Expression Total. But I wanted 'Sum Of Rows' Total Mode. Now anyone please tell me how to change that total mode from 'expression total' to 'Sum of Rows'??? Brijesh

2 Replies
brijesh1991
Contributor III

Re: Pivot Table total not proper

Hi All, I detected the problem. By default, Pivot table has Total Mode: Expression Total. But I wanted 'Sum Of Rows' Total Mode. Now anyone please tell me how to change that total mode from 'expression total' to 'Sum of Rows'??? Brijesh

Re: Pivot Table total not proper

You'll need the aggr function. Something like this:

=sum( aggr(yourexpression, Region, Campaign))