topic Re: Calculation in Pivot Table. in QlikView

Calculation in Pivot Table.

suzel404 — Sat, 28 Jun 2014 13:53:50 GMT

Hi all,

I need to calculate amount in pivot table.

Févr. Mars Calculation

5.13 6.23 (6.23 - 5.13) / 5.13 = 21%

How can I achive that ?

Re: Calculation in Pivot Table.

swuehl — Sat, 28 Jun 2014 14:03:33 GMT

You can use chart inter record functions like before() or above() (use before() in your case of pivoted dimensions):

="Prix Moyen TTC" / before("Prix Moyen TTC") -1

Re: Calculation in Pivot Table.

suzel404 — Sat, 28 Jun 2014 14:06:35 GMT

Thanks Swuehl.

It is exactly what I need.

Re: Calculation in Pivot Table.

suzel404 — Sat, 28 Jun 2014 15:05:13 GMT

Swuehl,

I can I have a total (%) rather than '-' ?

Re: Calculation in Pivot Table.

swuehl — Sat, 28 Jun 2014 15:23:53 GMT

Possibly, yes.

But, your total variance should indicate what based on your data? (How would you like it to be calculated?)

Re: Calculation in Pivot Table.

suzel404 — Sat, 28 Jun 2014 16:16:19 GMT

Total (%Prix Moyen) = Sum of Total(%) for Janv. + Sum of Total(%) for Févr. + Sum of Total(%) for Mars + Sum of Total(%) for Avr. + Sum of Total(%) for Mai + Sum of Total(%) for Juin