Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How do I add calculated items to a pivot table

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

4 Replies
Anonymous
Not applicable
Author

Add an Expression called 'Gross profit':

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

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

Anita

Not applicable
Author

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
Not applicable
Author

Are Income, Costs, Expenses dimensions?

Or are they part of dimension 'Type'??

Not applicable
Author

They are part of Type