Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
carlos13
Creator
Creator

AVG pivot table

I have the following table:

DATEABCTotal
31/12/2013   41.980.826.008    51.683.547.590      6.742.644.619    100.407.018.218
30/11/2013   42.488.250.790    51.951.483.509      7.322.630.578    101.762.364.877
31/10/2013   43.205.343.859    53.557.163.670      7.116.952.637    103.879.460.166
30/09/2013   44.241.516.622    52.011.540.832      8.792.556.502    105.045.613.956

I want have  a percentage column among  the total of the row. how is  calculation?

12.JPG.jpg

Any help is appreciated.

Thank you,

1 Solution

Accepted Solutions
Not applicable

Hi Carlos,

I understand that A, B and C are values from a Column_X and you are making a Sum of Colum_Value, if so, then you will have to use this:

Dimensions:

  • Date
  • Column_X

Expressions:

  • Sum(Column_Value) / Sum(total<Column_X > Column_Value)

I hope it helps you

View solution in original post

6 Replies
carlos13
Creator
Creator
Author

A,B,C are a field called MODIF

Not applicable

Hi Carlos

Is this what you need?

Lukasz

Not applicable

Hi Carlos,

I understand that A, B and C are values from a Column_X and you are making a Sum of Colum_Value, if so, then you will have to use this:

Dimensions:

  • Date
  • Column_X

Expressions:

  • Sum(Column_Value) / Sum(total<Column_X > Column_Value)

I hope it helps you

Not applicable

Hi,

You can make A / Total if this column already exists

Or A / Rangesum(A,B,C) if it doesn't

carlos13
Creator
Creator
Author

thank you very much

Not applicable

I am glad it solved your problem.

Ryuma