Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

suzel404
Contributor

Calculation in Pivot Table.


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 ?

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: Calculation in Pivot Table.

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

View solution in original post

5 Replies
Highlighted
MVP
MVP

Re: Calculation in Pivot Table.

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

View solution in original post

suzel404
Contributor

Re: Calculation in Pivot Table.

Thanks Swuehl.

It is exactly what I need.

suzel404
Contributor

Re: Calculation in Pivot Table.

Swuehl,

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


MVP
MVP

Re: Calculation in Pivot Table.

Possibly, yes.

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

suzel404
Contributor

Re: Calculation in Pivot Table.

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