Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
filip_duchateau
Not applicable

Change total in pivot table

Hi everyone,

I have a pivot table with 2 dimensions (operation and part) and 1 measure.  The table shows a partial sum for the dimension 'operation'.

I would like the partial sum to be over all dimensions, except for dimension 'FSB', while still showing 'FSB' in the table.  Is this possible ?

I have enclosed the qvw file.

All suggestions are welcome.

Thanks in advance.

1 Solution

Accepted Solutions
sunny_talwar
Not applicable

Re: Change total in pivot table

May be using this:

=If(Dimensionality() = 0, Sum({<Operation -= {'FSB'}>} LocationInv), Sum(LocationInv))

2 Replies
sunny_talwar
Not applicable

Re: Change total in pivot table

May be using this:

=If(Dimensionality() = 0, Sum({<Operation -= {'FSB'}>} LocationInv), Sum(LocationInv))

filip_duchateau
Not applicable

Re: Change total in pivot table

Hi Sunny,

Works perfectly.  Thanks for your help