Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
brijesh1991
Valued Contributor

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
Valued Contributor

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
Valued Contributor

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

Highlighted

Re: Pivot Table total not proper

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

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


talk is cheap, supply exceeds demand
Community Browser