How to make most recent year display on the last column ?

[#1]

Hi All

May i know How to display only the most recent year revenue amount ? meaning for PRECICON dispaly 2013 amount only.

I have this table from raw data file
COMPETITOR	year	2008	2009	2010	2011	2012	2013
PRECICON		27,506,170	18,658,312	22,227,810	26,113,938	23,799,000	18,935,000
PHOENIX		49,521,518	38,434,959	43,685,133	-	-	-
WAGO		7,076,152	6,303,671	8,992,308	-	-	-
INTERMECH		16,568,610	12,034,977	16,690,995	17,552,873	-	-
SMC		70,481,466	55,589,617	64,455,803	102,317,790	-	-
ROCKWELL		46,815,627	-	-	-	-	-
SIEMENS		679,874,000	542,037,000	-	-	-	-
MITSUBISHI		242,890,943	219,475,152	-	-	-	-
EUTECH		20,034,793	17,504,690	-	-	-	-
DAIFUKU		-	14,532,517	-	-	-	-
MOTION CONTROL GROUP		652,946	961,870	-	-	-	-
OMRON		23,090,565	18,486,801	-	-	-	-
I like to transform the above table to below :-
COMPETITOR	year	Current Yr3	Current Yr2	Current Yr1
PRECICON		26,113,938	23,799,000	18,935,000
PHOENIX		49,521,518	38,434,959	43,685,133
WAGO		7,076,152	6,303,671	8,992,308
INTERMECH		12,034,977	16,690,995	17,552,873
SMC		55,589,617	64,455,803	102,317,790
ROCKWELL		-	-	46,815,627
SIEMENS		-	679,874,000	542,037,000
MITSUBISHI		-	242,890,943	219,475,152
EUTECH		-	20,034,793	17,504,690
DAIFUKU		-	-	14,532,517
MOTION CONTROL GROUP		-	652,946	961,870
OMRON		-	23,090,565	18,486,801

[#2]

Enclosed my QV Doc.

[Anonymous · Accepted solution]

Paul

Does the attached give you food for thought ?

Best Regards,     Bill

[#4]

Hi Paul,

Find the most recent year revenue amount,

Year = {$(=Max (Year))}

Sum ({< Year = {$(=Max (Year)) } >} Sales)

sum({$<Year={$(=OnlyYear))}>} Sales)

Sum({<YEAR = {"$(=max(YEAR)-1)"}>}Sales)

[#5]

Hi Bill

your approach work best. Thank.

This is one of the reasons that make Qlik View so successful against it competitor.

Paul