topic Show the sum (Column Results) in QlikView

Show the sum (Column Results)

pgalvezt — Tue, 11 Feb 2014 12:31:05 GMT

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!

Re: Show the sum (Column Results)

hic — Tue, 11 Feb 2014 13:35:57 GMT

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

HIC

Re: Show the sum (Column Results)

pgalvezt — Tue, 11 Feb 2014 14:24:40 GMT

Hi Henric,

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

Thanks!

Re: Show the sum (Column Results)

hic — Tue, 11 Feb 2014 15:15:13 GMT

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

Re: Re: Show the sum (Column Results)

pgalvezt — Tue, 11 Feb 2014 15:43:01 GMT

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.

Re: Show the sum (Column Results)

hic — Tue, 11 Feb 2014 16:05:02 GMT

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