topic Re: YOY? in QlikView

YOY?

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

Can any one explain what we are showing for YOY Exactly?

if possible some basic expressions

I have seen the other threads also but with out knowing the basic I did't understand it ?

Re: YOY?

ThornOfCrowns — Tue, 08 Mar 2016 16:06:04 GMT

Year on Year, perhaps?

Re: YOY?

Anonymous — Tue, 08 Mar 2016 16:08:19 GMT

let me give some data like I have data from

01/01/2015 to 03/26/2016 .

I want show YOY calculation then what I have to show exactly ?

I have one more field called sales allso

Re: YOY?

santiago_respane — Tue, 08 Mar 2016 16:34:06 GMT

Hi,

i think "YOY" means Year Over Year and it measures growth, for example, how much your sales have increased or decreased over the last twelve months.

Calculation:

Subtract last year's number from this year's number. That will give you the total difference for the year (If it's positive indicates a year-over-year gain otherwise a loss.
Then, divide the difference by last year's number.
The resulting number represents the year-over-year growth rate.

Example

Last year sales 1,500,000.00

Current year sales 1,700,000.00

1. 1,700,000.00 - 1,500,000.00 = 200,000.00 (indicates a gain)

2. 200,000.00 / 1,500,000.00 = 0.13

3. 13% it is your YOY evolution trend

Hope this helps.

Kind regards,

Re: YOY?

Anonymous — Wed, 09 Mar 2016 07:36:50 GMT

can u give me some sample expression on this if possible

Re: YOY?

Anonymous — Wed, 09 Mar 2016 07:44:12 GMT

Did you check this?

Year-over-Year Comparisons

Re: YOY?

jagan — Wed, 09 Mar 2016 07:51:40 GMT

HI,

Try like this

=(Sum({<Month=, Date=, Year={'$(=Max(Year))'}>} Sales) - Sum({<Month=, Date=, Year={'$(=(Max(Year) -1))'}>} Sales))/

Sum({<Month=, Date=, Year={'$(=Max(Year))'}>} Sales)

Hope this helps you.

Regards,

Jagan.