Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Calculation of profit

Hi,

How to calculate profit i need to show in pivot table. !

thanks.

Tags (1)
1 Solution

Accepted Solutions

Re: Calculation of profit

Create Pivot table

Dimension= Category

Expression = Sum({<Name ={'REVENUE'}>} Value) - Sum({<Name ={'COST OF PROD'}>} Value)

1 Reply

Re: Calculation of profit

Create Pivot table

Dimension= Category

Expression = Sum({<Name ={'REVENUE'}>} Value) - Sum({<Name ={'COST OF PROD'}>} Value)

Community Browser