Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
try to change the sort for the quarter field in the properties->sort tab
Dear,
the one way is
You can create a Inline table which contains two fields,
Load * inLine
[
QuaterYear,Sequence
Q1/2011,1
Q2/2011,2
....
....
and soon.
then in the chart go to sort tab
and sort it by expression
=Sequence
else attach the sample file.
Thanks,
Mukram.
Hi Sasi,
This filed is in a cyclic group and currently using numeric sort. other fields are getting sorted correctly
Dear,
can you attach the sample file.
Thanks,
Mukram.
Hi Mukram,
Thanks for your suggestion. Is there any way, so that i can make use of the fields in my QVD itself?
CALENDER_QUATER &'/'&CALENDER_YEAR AS [Quarter Year], this is the script to generate Quarter Year
Hi,
Use State also
select State->ascending from Sort Tab
Regards,
Hi Saritha,
I would suggest to create a new field like
CALENDER_YEAR&right(CALENDER_QUATER,1) as sortnum
which wil return 20111,20112....20134. use the newly created field in sort (expression)
Please try it.
-Sundar
Hi,
have a look at attached application.
Now use sequence field to sort your data.
Regards
ASHFAQ
Load
Dual(Quarter, MakeDate(Right(Quarter, 4), Mid(Quarter,2,1)*3-2, 1)) as Quarter