thanks for your quick answer. MAybe im to "newbie" to understand yout help.
My Column3 (Expression) has the definition = Column(2) / Column(3) but that applies for the total as well, and i want qlikview to subtotal column4 instead of calculationg the subtotal.
That means in my example i have the total of column (4) that is 3 (33/11). I want it to be 11 (1+3+4+3).
Please explain for someone that is not that familiar.-.. thanks alot!!!!
Try using a straight table instead and set the Total Mode of Column 4 to Sum of Rows instead of Expression Total.
If you want to use a pivot table you will have to use the original expressions of column 2 and 3 and wrap them in another sum using the aggr function:
sum(aggr( ...expression_column2... / ...expression_column3..., DimensionColumn1)). Replace DimensionColumn1 with the name of the dimension of your pivot table.
thanks for your reply.
Actually the problem is, that column 2 and 3 each contain aggr ( ... ) functions. so that (i learned) i cannot do a function like aggr ( aggr ( ..., ....), ....). Or is that somehow possible using variables or something?
same problem with using straight tables, i think ... gonna test that a bit further.
the funny thing is, that if i use a bar chart, and stack column 4 (say colum 1 is "Month" and contains Jan, Jan, Jan, Feb, Feb, Mar, Mar, Mar, Mar, ... and so on) for each Month, i get the right subtotal for each month... but not in the pivot chart
a bit obscure...
thanks for any further advice.
@Mayil, i m gonna try to post some example during the day.
ty for your support.