topic Re: Growth formula issue in QlikView

Growth formula issue

prma7799 — Wed, 24 Aug 2016 06:00:05 GMT

I am facing some issue with on formula that is I have to create MoM chart with Growth for that I am using

Dim: = if(MonthEnd<Today(), MonthYear1 )

Expr:

for Sale :

fabs(Sum({<Year=, Quarter=, FiscalYear={">$(vFYM)"},[PostingDate]={">=$(=QuarterStart(min(PostingDate),4 ))<=$(=MonthStart(Today())))"}>} Amount))/100000

for Growth :

((Sum(Amount)-

above(Sum( Amount),12))/above(Sum(Amount),12)) * 100

VFYM:=Year(addyears(max([Posting Date]),-1))

using above in chart the data is coming properly But I want growth line I want to show from APR-15

Please find the attach

Re: Growth formula issue

sreenivas — Wed, 24 Aug 2016 06:12:56 GMT

Add the set conditions in the Growth formula too , as used i the Sales.

Re: Growth formula issue

prma7799 — Wed, 24 Aug 2016 06:17:55 GMT

Can you please explain bit more..

Re: Growth formula issue

sreenivas — Wed, 24 Aug 2016 06:20:29 GMT

{<Year=, Quarter=, FiscalYear={">$(vFYM)"},[PostingDate]={">=$(=QuarterStart(min(PostingDate),4 ))<=$(=MonthStart(Today())))"}>}

Add the set condition to filter data from Apr15 on wards in the expression

((Sum({"set condition"}Amount)-

above(Sum( {"set condition"}Amount),12))/above(Sum({"set condition"}Amount),12)) * 100

Re: Growth formula issue

prma7799 — Wed, 24 Aug 2016 06:30:06 GMT

Like this??

((Sum({<FiscalYear={">$(vFYM)"}>}Amount)-

above(Sum({<FiscalYear={">$(vFYM)"}>}Amount),12))/above(Sum(Amount),12)) * 100

Re: Growth formula issue

sreenivas — Wed, 24 Aug 2016 06:57:02 GMT

yes try the below one

((Sum({<FiscalYear={">$(vFYM)"}>}Amount)-

above(Sum({<FiscalYear={">$(vFYM)"}>}Amount),12))/above(Sum({<FiscalYear={">$(vFYM)"}>Amount),12)) * 100

Re: Growth formula issue

prma7799 — Wed, 24 Aug 2016 07:04:10 GMT

I tried this but growth figures showing incorrect.

Re: Growth formula issue

sreenivas — Wed, 24 Aug 2016 07:06:23 GMT

can you post sample data

Re: Growth formula issue

prma7799 — Wed, 24 Aug 2016 07:06:37 GMT

It is showing like this...

Growth showing only for last four quarter ..

Re: Growth formula issue

sreenivas — Wed, 24 Aug 2016 07:19:01 GMT

Hi Prasanth

check the attached file.

Re: Growth formula issue

prma7799 — Wed, 24 Aug 2016 07:36:09 GMT

Can you please tell me How to do this for Quarter also. I mean quarter wise Chart...