Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
May be this:
Num((Sum({<Año = {$(xAñoAnt)}>} Field1)/Divisor)/(Sum(TOTAL {<Año = {$(xAñoAnt)},Dim1,Dim2>} Field1)/Divisor),'#.##0,00%')
May be this:
Num((Sum({<Año = {$(xAñoAnt)}>} Field1)/Divisor)/(Sum(TOTAL {<Año = {$(xAñoAnt)},Dim1,Dim2>} Field1)/Divisor),'#.##0,00%')
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!
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.
Sorry My Bad, I forgot put the other dimenssion.
Works Fine.
Thanks!