Problem in the sequence of Calendar Quarter Year.

[#1]

Hi All,

I have a field in my Calendar Table in DB which contains a field related to  Calendar and stored into a QVD called Calendar. I am using  Year and Quarter fields from the QVD to get Quarter Year( eg: Q1/2014,Q2/2014,Q3/2014 etc). In the chart this field is not getting displayed in sequence. Attaching the screen shot. Please suggest me how to sort this. I have tried few ways and nothing was working.

Please help.

Thanks,

Saritha Xavier

[#2]

Hi,

Am  attaching a sample file with the calendar field i require. a list box is there with Quarter year

[MarcoWedel]

Hi,

this way sorting and date calculations are possible out-of-the-box:

LOAD Dual(Quarter, MakeDate(Right(Quarter, 4), Mid(Quarter,2,1)*3-2, 1)) as Quarter,
    Ceil(Rand()*100) as value
Inline [
Quarter
Q1/2012
Q2/2012
Q3/2012
Q4/2012
Q1/2013
Q2/2013
Q3/2013
Q4/2013
Q1/2014
Q2/2014
Q3/2014
];

hope this helps

regards

Marco

[sundarakumar]

PFA the applciation with fix for the sort issue,

-Sundar

[MarcoWedel · Accepted solution]

regards

Marco

[ashfaq_haseeb]

Hi,

Have a look to attached modified application.

Marco Solution work like a charm and its easiest to implement.

Regards

ASHFAQ

[engishfaque]

Dear Saritha,

Use this one, for quick solution.

'Q' & Ceil(Month(TO_DATE)/3) AS CalendarQuarter

Kind regards,

Ishfaque Ahmed

[#8]

thanks a lot Marko..this solved my problem...

thanks to all who gave me hepful answers

[#9]

Hi Marco,

I am having same problem while using below script as well...

'Q' & Ceil(Month(Date#(DISCHARGE_DT,'MM/DD/YYYY'))/3)  & ' ' & Year(Date#(DISCHARGE_DT,'MM/DD/YYYY'))) AS O_CalendarQuarter