topic Re: How Can i Calculate Profit Each Year for the below data..?? in QlikView

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

Silambarasan1306 — Wed, 24 Feb 2016 06:14:40 GMT

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 ??

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

sunny_talwar — Wed, 24 Feb 2016 09:47:47 GMT

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?

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

Anonymous — Wed, 24 Feb 2016 10:23:12 GMT

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!!

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

Anonymous — Wed, 24 Feb 2016 10:27:55 GMT

Revunue - Budget amount

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

Silambarasan1306 — Fri, 26 Feb 2016 05:40:20 GMT

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

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

Silambarasan1306 — Fri, 26 Feb 2016 05:40:56 GMT

Yaa that's the concept. Revenue-BudgetAmount