Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
If you make it into a Straight table, you can change the Total Mode on the Expressions tab.
HIC
Hi Henric,
Thank you for your reply. I know that but is possible to do that in a pivot table?
Thanks!
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
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.
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