topic Re: AVG pivot table in QlikView

AVG pivot table

carlos13 — Fri, 31 Jan 2014 16:57:18 GMT

I have the following table:

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

Any help is appreciated.

Thank you,

carlos13 — Fri, 31 Jan 2014 17:08:20 GMT

A,B,C are a field called MODIF

Fri, 31 Jan 2014 17:09:55 GMT

Hi Carlos

Is this what you need?

Lukasz

Fri, 31 Jan 2014 17:10:15 GMT

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:

Expressions:

I hope it helps you

Fri, 31 Jan 2014 17:12:01 GMT

Hi,

You can make A / Total if this column already exists

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

carlos13 — Fri, 31 Jan 2014 17:30:14 GMT

thank you very much

Fri, 31 Jan 2014 19:35:51 GMT

I am glad it solved your problem.

Ryuma