topic Re: Pivot table Totals in QlikView

Pivot table Totals

EGilbert — Fri, 07 Feb 2020 19:09:27 GMT

I have a question about Pivot tables. I am doing an analysis by region for some plants and I have a number of different capacities in my file. i need to select the lowest capacity listed for each plant. I then need to sum those capacities to get a total capacity by year. i have built the pivot table below and i get the mins fine but when it sums it follows the expression and shows the min value, rather than adding them together

How can I add the calculated mins together. The expression I used for the mins is :

min({$<[Capacity Type E]={"Installed"}>}[Harbour Capacity])

I tried dimension() but could not get the totals to work as it just keeps adding all the other values not shown as well.

Re: Pivot table Totals

petter — Sat, 08 Feb 2020 06:10:45 GMT

Have a look at this post which explains the solution to address you problem very well:

https://community.qlik.com/t5/QlikView-Documents/Sum-of-Rows-and-Expression-Total-Difference/ta-p/1486538

There is an attached QlikView application within the article as well.

Here is a screenshot of the main sheet:

Re: Pivot table Totals

EGilbert — Mon, 10 Feb 2020 15:34:27 GMT

Thanks for the reply

Re: Pivot table Totals

EGilbert — Tue, 18 Feb 2020 12:31:12 GMT

I was able to get the solution to work with the use of Dimensionality. Thanks all who replied