last 13 months data

[ajaykumar1]

Hi All,

1.How we can get the last 13 months data with out writing the 13 expressions in chart.

stuck some where to write the variable for 13 months and pass that to set analysis level.The field is 'Month' which is having around 20+ months data.

Thanks,

Ajay

[#2]

Hi, you should create a calendar, assigning a progressive id to every month, so that you have a key to identify each month.

then you can just insert

if(Month_ID > Max(Month_ID)-13, Month) as your dimension

[ajaykumar1]

Thanks Luca...

let me try the same

[ajaykumar1]

Hi its not working.

   load Month,

     sal,

     if(Month>max(Month)-13,Month) as month_derived,

[#5]

Any one is there  ????

[santharubban]

try this, AddMonths(MonthStart(Today()), -14) in dimension of chart.

or

load Month,

     sal,

      month_derived  from xxxx.qvd where date(month_derived)  => AddMonths(MonthStart(Today()), -14) ;

[#7]

No Luck Santhu.....

[santharubban]

what error ur getting?

[ajaykumar1]

I am getting only one record.... am trying to attach the qvw but am unable.

Month	sal	type
01/01/12	100	test
01/02/13	101	manf
01/03/14	102	tetst
01/04/15	103	hvv
01/05/16	104	vshvv
01/06/17	105	vvZ
01/07/18	106	vsv/
01/08/11	107	sgvugu
01/09/10	108	vslvhkls
01/10/09	a	ns;v
01/11/08	110	vsdhv
01/12/01	111	sgvugu
01/13/02	112	svdi
01/14/04	113	sdv;do
01/15/87	114	svdiwhp
01/16/86	115	shvsh;
01/17/85	116	sv;sv
01/18/80	117	vsh;v
01/19/12	118	sbh;bj'
01/20/12	119	ah;adoh
01/21/12	120	ab'adj'

[Carlos_Reyes]

I always use a MonthName field for this type of analysis. Review the attached to see an example.