topic Sum columns in table in QlikView

Sum columns in table

Fri, 22 Apr 2011 22:41:27 GMT

Hi Forum,

I have a straight table, with a column that is calling a variable, that has a complex calculation.

It works great, and sums it up at the bottom (Total Mode). which is what i want.

Now i want to use the "Total at the bottom" in another function in a column.

Prod Sales Sales / Units
XXX 1000 1/6
YYY 5000 5/6
TOTAL 6000

Ideas? without using sum( total field) since the current "Sales" function is complex.

Sum columns in table

vgutkovsky — Sat, 23 Apr 2011 00:14:22 GMT

Bernard,

So you want to do a sum of rows and show the results on the bottom row? You can set "sum of rows" in the Total Mode in the Expression tab and then move the total to the bottom in the Presentation tab. Unless I'm misunderstanding something...?

Regards,

Sum columns in table

Sat, 23 Apr 2011 00:24:56 GMT

hi Vlad,

Very close. I want to use the "sum of rows at the bottom" in another calculation. I have the "Total Mode" set for column1 and I get the bottom row Total. In the next column, column2, I want to use the "Total from the 'Total Mode" from column1 for all the rows.

Thanks,

bernard

Sum columns in table

vgutkovsky — Sat, 23 Apr 2011 00:28:38 GMT

Ah, sorry, now I get it. Use advanced aggregation. You mentioned that your expression is in a variable, which I'll call vExpression, and your dimensions Dim1 and Dim2. To use the total from the chart, use sum(aggr($(vExpression),Dim1,Dim2))

Cheers,