How Can i Calculate Profit Each Year for the below data..??

[Silambarasan1306]

I have data like this,

Year	Revenue
2007	119793.1348
2008	1153955.049
2009	3058935.989
2010	4891124.586
2011	3562331.138
2012	535098.1727

BudgetYear	BudgetAmount
2008	7000
2009	177000
2010	375000
2011	570000
2012	710000

Dont have budget amount for 2007.

1. How can i calculate Profit for Each Year.

2. Also tell me how can i hide the 2007 revenue values.

                                                           Can anyone help me ??

[sunny_talwar]

How would you calculate profit outside of QlikView using the data provided? I would think profit  = Revenue - Cost. What is your cost here??? or do you want Revenue - Budget?

[Anonymous]

try like this?

MainTable:

Load

Year,

Revenue

From Table

where Year>2007;

concatenate(MainTable)

Load

BudgetYear as Year,

BudgetAmount

From Table1;

I am assuming Profit is calculated is like : Revenue - BudgetAmount

Take Year as a Dimension and above expression as a Measure

Hope this will help!!

[Anonymous]

Revunue - Budget amount

[Silambarasan1306]

  If i'm concatenating, values coming like this, because the years are not matching. If years matching values will be change. how to do this..???  i also need 2007.

Year
2008
2009
2010
2011
2012
2007
2008
2009
2010
2011
2012

[Silambarasan1306]

Yaa that's the concept. Revenue-BudgetAmount