Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all ,
i am hvng data as
quarter
Q1
Q2
Q3
Q4
,year
2009
2010
2011
2012
,month,
jan
.
.
.
.dec
so the result vil b lik dis..
i wan year field as 2009Q1
2009Q2
2009Q3
2009Q4
like so on...upto 2012
means evry year i vil get wit in qurters
Please help me...
sorry try like this
Year & Quarter as YearQuarter
you can concatenate your fields like this
Load *,
Year&Quarter as YearQtr;
load * inline [
Year,Quarter,Month
2011,Q1,Feb
2012,Q3,Aug
2009,Q2,Jun
];
Okay Bhavana ..Tanq fr Sugg..i wil try
hI FIND BELOW SCREEN SHORT..
Hvng am hvng 2year data
if i select Q1 of 2010 display 2009 Q4
2010
Q1--->Q2
Q2---->Q3
Q3---->Q4
Q4---->Q1 if Q4 select dispay previous year Q1 Data so Plase Find

Can you please clarify your pbm statement clearly and send me your .qvw file as well.
Thanks
Lathaa
Please clarify your problem properly.
hi,,
In year 2009 four quaters Q1 to Q4
In year 2010 four quatersQ1 to Q4
if i select q1 in 2010 it wil disply 2009 q4 details lik so on...
means if v select q3 v vil disply q2 .....
Its clear that if Q1 of 2010 selected it will display data of Q4 of 2009. Its fine. Now what do you want if Q3 of 2010 is selected? Please clarify.
Hi,
see this qvw.It is correct answer.