Qlik Community

QlikView Extensions

Discussion Board for collaboration on QlikView Extensions.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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

20132014
279.546.344265.724.1964,91%
284.068.63250.038.4354,99%
2.461.684.2472.396.134.30143,25%
1.017.790.2511.052.756.85217,88%
58.968.10339.347.9021,04%
53.482.77246.779.3170,94%
1.254.410.6431.673.510.43022,04%
93.477.68025.073.3051,64%
76.939.347170.740.1111,35%
111.378.98261.719.8251,96%
5.691.747.0015.781.824.674

Thanks!

1 Solution

Accepted Solutions
bill_markham
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
bill_markham
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.

PrashantSangle
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.
elena888
Not applicable

Re: Percentage by total


See this.

ecolomer
Not applicable

Re: Percentage by total

See this:

p02.png