topic Re: Growth line for three years in QlikView

Growth line for three years

prma7799 — Wed, 25 Nov 2020 16:16:04 GMT

Dear All,

I have quarteryear fields as dimension and below are my expression

1.QuarterOnQuarterSale

fabs(sum({<FiscalYear={">$(vFY)"},[Date]={">=$(=YearStart(min({$<FiscalYear={$(=min(FiscalYear))}>}[Date]),0,4))<=$($(vQY))"}>}[Amount])/100000)

2.Growth of all Quarter

((fabs(Sum(Amount))-above(fabs(Sum(Amount)),4))/above(fabs(Sum(Amount)),4)) * 100

Variable values

vFY=Year(addyears(max([Date]),-4))

vQY=QuarterStart(Today())

I almost done with my requirement but I don't want below highlight growth line for Q1 11 to Q4 12

PFA....

Thanks

Re: Growth line for three years

sunny_talwar — Fri, 26 Aug 2016 09:22:53 GMT

Would you be able to provide a sample to work with?

Re: Growth line for three years

prma7799 — Fri, 26 Aug 2016 10:02:30 GMT

stalwar1‌

After open please do clear all

Re: Growth line for three years

sunny_talwar — Fri, 26 Aug 2016 10:11:05 GMT

There are two ways to do this:

((fabs(Sum(GL_Amount))-above(fabs(Sum(GL_Amount)),4))/above(fabs(Sum(GL_Amount)),4)) * 100 *

Avg({<FiscalYear={">$(vFY)"},[PostingDate]={">=$(=YearStart(min({$<FiscalYear={$(=min(FiscalYear))}>}[PostingDate]),0,4))<=$($(vQY))"}>} 1)

If([Sales] > 0, ((fabs(Sum(GL_Amount))-above(fabs(Sum(GL_Amount)),4))/above(fabs(Sum(GL_Amount)),4)) * 100)

I suggest option 1, but option 2 is available in the chart as well

Re: Growth line for three years

prma7799 — Fri, 26 Aug 2016 11:57:27 GMT

Thanks Sunny

I really appreciate your help...

Can you please tell how can I achieve YoY chart like attachment .

Many Thanks

Re: Growth line for three years

sunny_talwar — Fri, 26 Aug 2016 12:38:36 GMT

This?

=Sum(GL_Amount/1000) - Below(Sum(GL_Amount)/1000)

Re: Growth line for three years

prma7799 — Sat, 27 Aug 2016 04:22:24 GMT

Hi Sunny,

Thanks for your quick reply.

I need data for only five years.

Thanks

Re: Growth line for three years

sunny_talwar — Sat, 27 Aug 2016 10:20:09 GMT

But I wonder if the numbers make sense?

Re: Growth line for three years

prma7799 — Mon, 29 Aug 2016 11:52:48 GMT

Hi stalwar1‌,

Like above I need to show only five year of data with growth.

Thanks

Re: Growth line for three years

sunny_talwar — Mon, 29 Aug 2016 12:21:05 GMT

Can you elaborate on what you are looking for? May be expected output in an Excel file?

Re: Growth line for three years

prma7799 — Tue, 30 Aug 2016 03:31:54 GMT

stalwar1‌

I am looking like this ...

Only five years data with growth line.