topic Re: Growth in Expression in QlikView

Growth in Expression

mario-sarkis — Thu, 26 Feb 2015 15:03:06 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,

Please attachement a sample of my current Date in a QVW file and its source:

Re: Growth in Expression

Gysbert_Wassenaar — Thu, 26 Feb 2015 15:06:10 GMT

You can use the above() function to calculate these values. For example sum(amount)/above(sum(amount))-1. Replace sum(amount) with your expressions.

Re: Growth in Expression

mario-sarkis — Thu, 26 Feb 2015 15:17:33 GMT

Please Can you send me the Qvw based on my example cause it didn't work .

Thanks alot!!

Re: Growth in Expression

mario-sarkis — Fri, 27 Feb 2015 07:51:10 GMT

ali_hijazi

Hey Ali Please check if You can help Thanks alot:)