YoY growth Set Analysis

[#1]

Hi Hope someone helps. Thanks in anticipation. I have a table as below-:

Year	A	A YoY	B	B YoY	C	C YoY
2004	120795		365483		75200
2005	123398		367395		75700
2006	125414		374767		78424
2007	154304		376328		75000
2008	152405		375000		80000
2009	150228		397001		85600

What I would like the set analysis to do is to fill the YoY. This will be a straight table that I would be using in QlikView sheet. I have imported the table as it is with the numbers alone for (A,B,C) and trying to create expression for A YoY, B YoY etc. Now I need help to plot this as expression, How can i show A YoY (i.e- 2005 vs 2004 year number 123398/120795) and so on in %.

[Miguel_Angel_Baeyens]

Hello,

Use the inter-record functions, in your case, Above(). So the A YoY will look like

[ A ] / Above([ A ])

(Don't leave blanks between brackets and A, I do this because of the forum smileys)

The in the chart properties, Numbers tab, fix it to say two decimals and check Show in percent (%)

Hope this helps

[#3]

Thats great! Thanks, it worked.

[#4]

Hello,

I'm also looking something on YOY, below is my sample table -

and I am looking here for YOY % based on Column X something like that >> (Rev for current year - Prev Year Rev)/ Prev year Rev

but the base should be column X i.e. agg SUM with respect to X for YOY ananlysis and i want to plot it to line chart as well.

- also is there anything in QV where i can reuse this formulas by creating some variable kind of as we do in BO if some one aware.

Seg	Year	Cntry	X	Rev	YOY Growth
A	2009	Australia	AC	6028.606446
A	2009	Australia	AT	738.170168
A	2009	US	AV	11.976399
A	2010	US	AC	6437.413061
B	2010	Brazil	AT	788.226321
B	2011	Brazil	AC	6658.678384
B	2011	Japan	AT	815.31906
B	2011	Japan	AV	13.228097
B	2012	Italy	AC	7298.942505
C	2012	Japan	AT	893.71593
C	2012	Japan	AV	14.500042

Please assist would be of great help.

Thanks..

[#5]

Anything please, still struggling 😞

[#6]

http://community.qlik.com/message/122958#122958