topic Re: Growth in QlikView

Growth

gautik92 — Fri, 31 Oct 2014 05:45:37 GMT

How to calculate the growth comparing the MT value?i have attached sample data

its_anandrjs — Fri, 31 Oct 2014 05:53:10 GMT

In the above chart you have 1 dimension and 2 expression used with Combo chart.

Dimension:- Year&'-'&Quarter

Expression:- Sum(MT Value) //This is in Bar

Expression:- Sum( GrowthExpressionHere) //Any calculated formula for Growth calculation and this is are in line graph.

Regards

Anand

gautik92 — Fri, 31 Oct 2014 06:18:43 GMT

How to calculate the growth??

Fri, 31 Oct 2014 06:27:47 GMT

Growth may be like:

(sum([MT Value]) - above(sum([MT Value])))/sum([MT Value])

Hope this was helpful.

Thanks,

Singh

its_anandrjs — Fri, 31 Oct 2014 06:32:51 GMT

There is different formula for this may be your side is different but you can use

( sum([MT Value]) - (sum(Previos Quarter value [MT Value])))

sum(TOTAL [MT Value])