Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

Problems with subtotals in pivot table

Hello everyone. I need your kind help, please.

I would like to know if it is possible and what would be the solution for this type of problem:

I have a pivot table box that shows me the totals and subtotals by 'CENTROS' (CENTRO ORIGEN and CENTRO DESTINO); So far the result is correct.

imag1.png

However, when I want to filter rows that only paint the red '%', the result for totals and subtotals are not correct.

imag2.png

I would like to know, if the subtotals respect the conditionals that I put in the expression. What can the error be due to?

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Problems with subtotals in pivot table

I assume that you need an aggr-function around your expressions to get the correct totals. I mean something like this:

sum(aggr(YourExpression, Dim1, Dim2, ...))

- Marcus

View solution in original post

1 Reply
MVP & Luminary
MVP & Luminary

Re: Problems with subtotals in pivot table

I assume that you need an aggr-function around your expressions to get the correct totals. I mean something like this:

sum(aggr(YourExpression, Dim1, Dim2, ...))

- Marcus

View solution in original post