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.
Solved! Go to Solution.
the one way is
You can create a Inline table which contains two fields,
Load * inLine
then in the chart go to sort tab
and sort it by expression
else attach the sample file.
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
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.