Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
Showing results for 
Search instead for 
Did you mean: 
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
Champion III
Champion III

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:


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