QlikView is showing all values as totals

[pgalvezt]

Hello,

I have a straight table with many expression. in my last expression I have this:

Num((Num(sum( {< Año = {$(xAñoAnt)}>} Field1)/Divisor,'#.##0')) /

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

Basically what I want is divide a value by the total...

But QlikView is showing al values as 100%,

Value A 100%

Value B 100%

Value C 100%

When I do clic over some value (for Example Value A) QlikView shows the real total 35,3%,

So in my table looks like Image.

Thanks!

[sunny_talwar · Accepted solution]

May be this:

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

[pgalvezt]

I tried that too, QlikView show the real result.

But is there a way to show the same result when I do clic over the value?

For example,

Value A 43%

Value B 35%

Want this

I do clic over Value A and shows 43% and not 100%,

Thanks!

[sunny_talwar]

Dim1 and Dim2 are your chart dimensions??

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

If it is, then it should be doing what you want.

[pgalvezt]

Sorry My Bad, I forgot put the other dimenssion.

Works Fine.

Thanks!