topic Re: Growth Expression in QlikView

Growth Expression

mario-sarkis — Tue, 24 Feb 2015 16:11:51 GMT

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.

Re: Growth Expression

MK_QSL — Tue, 24 Feb 2015 16:50:04 GMT

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

Re: Growth Expression

sunny_talwar — Tue, 24 Feb 2015 17:26:05 GMT

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,

Re: Growth Expression

mario-sarkis — Wed, 25 Feb 2015 07:16:31 GMT

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,

Re: Growth Expression

mario-sarkis — Wed, 25 Feb 2015 07:50:47 GMT

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

Re: Growth Expression

sunny_talwar — Wed, 25 Feb 2015 11:22:30 GMT

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,

Re: Growth Expression

mario-sarkis — Wed, 25 Feb 2015 12:25:15 GMT

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 .

Re: Growth Expression

mario-sarkis — Wed, 25 Feb 2015 12:38:55 GMT

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,