topic Re: How To emulate a straight table (sum) in QlikView

How To emulate a straight table (sum)

pgalvezt — Tue, 31 Jan 2017 17:39:05 GMT

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))))

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

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

Thanks!

Re: How To emulate a straight table (sum)

vishsaggi — Tue, 31 Jan 2017 18:05:04 GMT

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

Re: How To emulate a straight table (sum)

pgalvezt — Tue, 31 Jan 2017 18:29:42 GMT

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%.

Re: How To emulate a straight table (sum)

vishsaggi — Tue, 31 Jan 2017 19:09:18 GMT

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

Re: How To emulate a straight table (sum)

pgalvezt — Tue, 31 Jan 2017 20:13:45 GMT

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!

Re: How To emulate a straight table (sum)

vishsaggi — Tue, 31 Jan 2017 20:17:13 GMT

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

Re: How To emulate a straight table (sum)

pgalvezt — Tue, 31 Jan 2017 20:56:59 GMT

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

Thanks!