topic Calculations in rows and columns of a pivot table in QlikView

Calculations in rows and columns of a pivot table

Fri, 23 Apr 2010 15:54:23 GMT

In a pivot table i'm not able to construct a very basic financial report which makes calculations in rows

(expression calculations eg. Sales/kg) & calculations in columns (dimension calculations eg. growth 2009 > 2010).

Example report :

2010 2009 Growth%

volume(Kg)

sales

sales/Kg

As far as I know calculations are only supported in the Expression tab. Even with set analysis this doesn't seem

possible.

Any idea ??

Gino Bockaert.

Calculations in rows and columns of a pivot table

boorgura — Fri, 23 Apr 2010 16:32:11 GMT

Yes, it is possible.

Once you have the expression ready for 2010 and 2009.

In the 3rd expression named Growth%, use the following expression.

=num(((Column(1) - Column(2)) / Column(2)), '##.## %')

Let me if works (or any issues.)

Calculations in rows and columns of a pivot table

Sun, 25 Apr 2010 11:32:10 GMT

Thx for your reply Rocky !

In expression tab you can indeed perform the calculation you suggested.

However in the sample report the expressions are placed in the pivot table rows
and calculations (sales/kg) have already been done there.
The growth calculation between 2009 and 2010 is a calculation between dimension
members. I don't see how this can be done in a QV pivot table .

If you any more suggestions, please let me know .

Thx !

lionel.