Show the sum (Column Results)

[pgalvezt]

Hello,

I have many multiplications as many columns into my set analisys. 4 of them is the result of another multiplication. The problem is that the result is too big so QlikView Thrown a $ like result. If I export an Excel the result is 5434323543462345452 (as example). What I want is display the sum and not the multiplication in the final result in the column.

Example

= Column (X) * Column Y

Column X   Column Y  Column Z

5                    5               7

The result in column Z is 25.

7 would be the result of the sum of the column and not the result of the multiplication.

Thanks!

[hic]

If you make it into a Straight table, you can change the Total Mode on the Expressions tab.

HIC

[pgalvezt]

Hi Henric,

Thank you for your reply. I know that but is possible to do that in a pivot table?

Thanks!

[hic]

No. Then you need to re-write the expression using the Aggr() function:

     Sum(Aggr( A * B , Dim1, Dim2 ))

where A is the aggregation behind ColumnX, B is the aggregation behind ColumnY, and Dim1 and Dim2 are the dimensions of the chart.

HIC

[pgalvezt]

with 2 columns is easy. Can you help me with my formula? I tried to take your fomula but give error.

I attached what I want. And What I have.

[hic]

In principle it should just be to add

     Sum(Aggr(

before the expression, and

     ,Año,Familia))

after the expression. But I cannot find the place where you multiply two aggregations with each other.

HIC