Growth Expression

[mario-sarkis]

Hey all,

I need to know how can i calculate the growth in a line chart in several time.

Example:

Suppose that we have this data:

Date.            Data

Dec-12.        100

Dec-13.         150

Dec-14.          200

The groth that i need to show is :

Date.         Growth

Dec-13.    ((150-100)/2)*100

Dec-14.    ((200-150)/2)*100

Ps:i have these three dates but in the growth formula i need to show on the line chart Dec-13 and Dec-14 only.

In my you can see attached file the QVW and its source

Thank you.

[MK_QSL]

(Above(SUM(DATA))-SUM(DATA))*100/2

[sunny_talwar]

Do you need the Categorie_Flag drilldown to be one of your dimension in the chart as well??? or you just need the Date as dimension??

Best,

S

[mario-sarkis]

Hi Sunindia,

Yes the Categorie_Flag drilldown to be one of your dimension in the chart as well, and i need to calculate the Growth as i sent in the Example.

Hope that you can help.

Thank you,

[mario-sarkis]

Re: Congratulations ! Gysbert Wassenaar
Please fine attached QVW and it source Thank Gysbert

[sunny_talwar]

Are you looking to calculate growth across different different categorie_flag? I mean how is it useful in knowing what was the growth from 2012 Retail to 2015 Commercial? It would make sense if everything else stays the same and the only change is in the year.

Are you sure that the sample Excel file you have provided is complete in the sense that it will give you the output you are looking for? (because there are only 3 rows and categorie_flag has only 1 repetition, whereas categories flag has none.

Please let me know if you still want to know the growth rate regardless of your drill_down selection?

Best,

S

[mario-sarkis]

this is  a sample data, my data it looks the same but of caurse eac field has a repetition ex:

Categorie_Flag	Sub-Categories	Categories	CreditLoans	Dates	Volume
Commercial	Forestry	Agriculture	Total Lending	Dec-14	3372.000000
Commercial	Commercial Sea Fishing	Agriculture, Fisheries, and Forestry	Total Lending	Dec-13	32457.000000
Retail	cars	Indivduals	Total Lending	Dec-12	254535.000000
Commercial	Animal Husbandry	Agriculture	Total Lending	Dec-13	12000000
Commercial	x	Agriculture	Total Lending	Dec-12	15000000
Commercial	y	Agriculture, Fisheries, and Forestry	Total Lending	Dec-14	15000001
Retail	house	Indivduals	Total Lending	Dec-14	15000002
Retail	education	Individuals	Total Lending	Dec-12	1200000

my demensions on the line chart will be exactly as i sent in the QVW file in growth will from year to year  the formule should be exactly as i sent before.

If u can help please .

[mario-sarkis]

example of Growth

Date          Volume-Sub-Categories     Volume-Categories    Volume-CategorieFlag

Dec-12      200                                           500                              1000     
Dec-13      300                                           600                              1200    

Dec-14      400                                           800                              1600

the Growth Shows in a line Chart will be calculated as:

Date          Volume-Sub-Categories     Volume-Categories    Volume-CategorieFlag

Dec-13       (300-200)/200                      (600-500)/500             (1200-1000)/1000

Dec-14       (400-300)/300                      (800-600)/600             (1600-1200)/1600

My dimenssions on a line Chart will be :

1-Date

2-GroupFields ( Category Flag >>Category>>Sub-Categories)

Hope this will help More and much clearer then the first example.

Thanks Again,