Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Calculations in rows and columns of a pivot table

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.



2 Replies
boorgura
Valued Contributor

Calculations in rows and columns of a pivot table

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.)

Not applicable

Calculations in rows and columns of a pivot table

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.

Community Browser