its better to create in script side if don't then use list box-->properties-->general--> fields drop down it go to expression side
'Q' & Ceil(Month(TempDate)/3) if you want to start quarter first to jan
if you need to start quarter from apirl then try this expression
here TempDate is my date field replce with your own
hope it helps
For linking between your Quarter and data ,you need to add quarter in script.
Load * inline
join this Month with your fact table Month.
if you have monthno in fact table then you could write 1,2,3,4..12 in themonth column in replacement of jan,feb..dec and join with monthno of fact table.
Please see the attch file.
I have taken the month field data from xl file to show the demo.But in your data model there should be month field ,so you dont need to create xl file in your QVW. Just take the month field data that is already in your qvw file.
Already i have the date and Month field in my qvw file. Just i need to display the all Quarter values without modifying the script.
I tried the Mohit Answer. (Q' & Ceil(Month(TempDate)/3)) - This display the quarter values based on the selection. But I need to display the all quarter values.
can you help me on this?