topic Re: AVG in pivot table for some Values in QlikView

AVG in pivot table for some Values

francisvandergr — Wed, 24 Jun 2015 14:40:54 GMT

In my pivot table i wanna see for some values an avg in relation to the total for that period.

And some colours if the value is higher or below the avg over the total period for the same relative.

I have included an example for this question.

sunny_talwar — Wed, 24 Jun 2015 15:17:23 GMT

For part 1 you want to see the avg for just L and O or avg of A, B, C, L. I, O?

For part 2 can you re-explain please

Best,

Sunny

francisvandergr — Wed, 24 Jun 2015 15:31:34 GMT

Hi Sunny,

1. Indeed just for L and O but in relation to all.

For example month 1:

A 10

B 20

C 30

L 40

O 100

I wanna see an avg after L from 20% 40 / 200

I wanna see an avg after O from 50% 100 / 200

sunny_talwar — Wed, 24 Jun 2015 15:41:42 GMT

Is this the output you are hoping to see?

francisvandergr — Wed, 24 Jun 2015 17:36:07 GMT

Top thnx!