Solved: Re: Percentage by total - Qlik Community

pgalvezt · ‎2014-12-24

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!

Anonymous · ‎2014-12-24

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.

View solution in original post

Anonymous · ‎2014-12-24

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.

PrashantSangle · ‎2014-12-24

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.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Anonymous · ‎2014-12-24

See this.

ecolomer · ‎2014-12-24

See this: