# QlikView Extensions

Discussion Board for collaboration on QlikView Extensions.

Announcements

Not applicable

## Percentage by total

Hello!

I have tried to obtain the percentage by total. Sum(Monto)/Sum(TOTAL(Monto)) but doesn't work

also I tried Sum(Monto)/Sum(TOTAL(<Dimension>Monto))

 2013 2014 279.546.344 265.724.196 4,91% 284.068.632 50.038.435 4,99% 2.461.684.247 2.396.134.301 43,25% 1.017.790.251 1.052.756.852 17,88% 58.968.103 39.347.902 1,04% 53.482.772 46.779.317 0,94% 1.254.410.643 1.673.510.430 22,04% 93.477.680 25.073.305 1,64% 76.939.347 170.740.111 1,35% 111.378.982 61.719.825 1,96% 5.691.747.001 5.781.824.674

Thanks!

1 Solution

Accepted Solutions
Not applicable

## Re: Percentage by total

Try an expression of

Sum(Monto)/Sum(TOTAL <Periodo> Monto)

You also have loads of rows where [Activo_Circulante]  is null so untick Suppress When Value Is Null from it on the dimension tab.

4 Replies
Not applicable

## Re: Percentage by total

Try an expression of

Sum(Monto)/Sum(TOTAL <Periodo> Monto)

You also have loads of rows where [Activo_Circulante]  is null so untick Suppress When Value Is Null from it on the dimension tab.

Not applicable

## Re: Percentage by total

Hi,

Try like,

Sum(Monto)

/

SUM(TOTAL<Periodo> Monto)

*100

and change format from number tab.

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Not applicable

See this.

Not applicable

## Re: Percentage by total

See this:

Community Browser