topic How do I add calculated items to a pivot table in QlikView

How do I add calculated items to a pivot table

Tue, 09 Mar 2010 13:14:51 GMT

I have the following pivot table

Type Amount

Income 100

Costs 20

Expenses 50

I want Qlikview to add a row called "Gross profit" being Income less Costs below Costs.

How do I do that?

Louis Kruger

Anonymous — Tue, 09 Mar 2010 13:35:23 GMT

Add an Expression called 'Gross profit':

([Income] - [ Costs]) / [Costs]

Just make an calculated expression which does the calculation you request.

Anita

Tue, 09 Mar 2010 14:20:24 GMT

Anita, thank you for your response.

I have added Gross profit to expression label and ([Income] - [Costs]) to the definition window.

and what I get is

Type

Income sum(Amount) 100

Gross profit -

Costs sum(Amount) 20

Gross profit -

Expenses sum(Amount) 50

Gross profit -

and what I want is

Type

Income 100

Costs 20

Gross profit 80

Expenses 50

where do I go wrong?

Anonymous — Tue, 09 Mar 2010 14:37:12 GMT

Are Income, Costs, Expenses dimensions?

Or are they part of dimension 'Type'??

Tue, 09 Mar 2010 14:56:47 GMT

They are part of Type