Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Pivot chart - columns with Totals

I can't seem to get totals into my pivot chart.

I'm looking for this result:

BUClusterSiteProcessActivityUOMTot Act. Hr08-09 Act. Hr09-09 Act. Hr10-09 Act. HR
InboundUnloadPallets147604047
OutboundPickBoxes33011012298
OutboundLoadPallets130505030
OperationsSupervisionHour3616812

In my example I've added 3 days, but it should be possible to show every day of the year.

For the column Tot Act. Hr I'm trying to add a calculated dimension - but I'm not getting the calculation right.

Can anyone help me out?

1 Solution

Accepted Solutions

Re: Pivot chart - columns with Totals

You need to use the aggr function in the calculated dimension. See attached qvw.


talk is cheap, supply exceeds demand
2 Replies

Re: Pivot chart - columns with Totals

You need to use the aggr function in the calculated dimension. See attached qvw.


talk is cheap, supply exceeds demand
Not applicable

Re: Pivot chart - columns with Totals

aggr(sum([Total Act],Process)

Community Browser