Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Subtotals in pivot table

I am using this expression

sum({< GL_Ac = {'Grs'},Fl_CY={1},[Cy Code_]={'US'} >} Amount*-1*$(v_R_Sel1))/1000 in a pivot table and i have checked the show partial sums for both the dimensions. Now the totals doesn't show the right value but when i do use the aggr then it does. I am confused on why am i having the difference here? i was hoping that the pivot table does show subtotals by default and wouldn't be needing to use the aggr unless required. Any thoughts on this one?

The attached spread sheet is an export of the object that i am using the expression, which shows 1082 as total but when i really add up by row it is 1090.

1 Reply
Not applicable

Re: Subtotals in pivot table

Without more detail information, your issue looks like QlikView Technical Brief - AGGR

Community Browser