Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

YOY?

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 ?

1 Solution

Accepted Solutions
jagan
Luminary Alumni
Luminary Alumni

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.

View solution in original post

6 Replies
ThornOfCrowns
Specialist II
Specialist II

Year on Year, perhaps?

Anonymous
Not applicable
Author

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

santiago_respane
Specialist
Specialist

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:

  1. 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.
  2. Then, divide the difference by last year's number.
  3. 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,

Anonymous
Not applicable
Author

can u give me some sample expression on this if possible

Anonymous
Not applicable
Author

Did you check this?

Year-over-Year Comparisons

jagan
Luminary Alumni
Luminary Alumni

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.