Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Total is not for all columns working in Pivot Table

I'm working on a Pivot Table and trying generate some Totals and Subtotals. There are 6 columns and for 4 columns total is displayed and for other 2 it isnt working. I tried to lookup data in Excel sheet and it was recognising as TEXT in excel.

Then I have changed it to different format in QV chart properties, but still it isnt working. Any solutions to this?

1 Reply
MVP
MVP

Re: Total is not for all columns working in Pivot Table

In pivot tables, the total line is always calculated by applying your expression to the current data set.  In other words, it completely ignores your dimensions.  It does not do a sum of rows.  That doesn't matter for some simple expressions like sum(Sales).  But it can matter for other expressions.

To get a sum of rows in a pivot table, replace your current expression with this:

sum(aggr(YourCurrentExpressionHere,Dimension1,Dimension2,etc))

I don't know if this is the actual problem, but it's my only guess at this point.

Community Browser