How To emulate a straight table (sum)

[pgalvezt]

Hello,

This formula in my straight table (Total Mode = sum) works fine.

I need the same total in my text object: (I tried adding Sum(Aggr(...)),Dim2,Dim3)) but QlikView show me the total expression. I would like to obtain the sum of my formula.

Num((((Avg(Aggr(Num(Sum(Field1)/Divisor,'#.##0')/Sum(Field2),Dim1)))

-

(Avg(Aggr(Num(Sum({< Año = {$(xAñoAnt)}>}Field1)/Divisor,'#.##0')/Sum({< Año = {$(xAñoAnt)}>}Field2),Dim1))))

/

(Avg(Aggr(Num(Sum({< Año = {$(xAñoAnt)}>}Field1)/Divisor,'#.##0')/Sum({< Año = {$(xAñoAnt)}>}Field2),Dim1))))

*

(Num((Sum({<Año = {$(xAñoAnt)}>} Field1)/Divisor)/

(Sum(TOTAL {<Año = {$(xAñoAnt)},Dim2,Dim3>}  Field1)/Divisor),'#.##0,00%')),'#.##0,00%')

Thanks!

[vishsaggi]

Would be able to share a sample app and expected value you want in your text object?

[pgalvezt]

Hi Vishwarath Nagaraju :

I Can´t.

But my Total is 40%,

This Mount change when I do Clic in sum in (Total Mode - Straight Table) ... Thrown 5,78%.

In my Text Object I get show 40% but not 5,78%.

[vishsaggi]

There is somthing which i am not able to catch it in that long expression. A sample app would help us to look into it.

You can scramble the data and then upload your sample file.

Preparing examples for Upload - Reduction and Data Scrambling

[pgalvezt]

I did the following,

I created the same table with the same formula, and have edited the style fuctions until left it as a text object.

Thanks!

[vishsaggi]

Didn't get you, did you get what you wanted or ?

[pgalvezt]

Yes, I did it but in a different way than usual.

Thanks!