Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

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
Highlighted
MVP & Luminary
MVP & Luminary

Re: YOY?

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
Highlighted
Specialist II
Specialist II

Re: YOY?

Year on Year, perhaps?

Highlighted
Creator III
Creator III

Re: YOY?

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

Highlighted
Specialist
Specialist

Re: YOY?

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,

Highlighted
Creator III
Creator III

Re: YOY?

can u give me some sample expression on this if possible

Highlighted
Champion
Champion

Re: YOY?

Did you check this?

Year-over-Year Comparisons

Highlighted
MVP & Luminary
MVP & Luminary

Re: YOY?

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