Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, Can any one please help me.
I have only the Year wise Data like
2012
2013
2014
But i need Quarter wise Data
Q1 DATA in 2012
Q2 DATA in 2012
Q3 DATA in 2012
Q4 DATA in 2012 like this how i can i get
Please help me
HI,
The below example will return all quarter in same value. because you don't have month wise data.
Create some dummy inline table with qear and quarter fields and link your data year field and dummy data year field.
Ex:
Quarter:
LOAD * INLINE [
Year, Quarter
2012, Q1
2012, Q2
2012, Q3
2012, Q4
];
If you don't have any Date dimension, this is not possible to get.
HI,
The below example will return all quarter in same value. because you don't have month wise data.
Create some dummy inline table with qear and quarter fields and link your data year field and dummy data year field.
Ex:
Quarter:
LOAD * INLINE [
Year, Quarter
2012, Q1
2012, Q2
2012, Q3
2012, Q4
];
u can use inline
e.g
load * inline
[S.No,Year,Quarter
1,Jan,Q1,
2,Feb,Q1,
3,Mar,Q1,
4,Apr,Q2,
5,May,Q2,
6,Jun,Q2,
7,July,Q3,
8,Aug,Q3,
9,Sep,Q3,
10,Oct,Q4,
11,Nov,Q4,
12,Dec,Q4
];
and for Quarter 2012 use it as always selected value
If you have Date field, try this (on script):
CEIL(MONTH(Date)/4) AS Quarter
Hi,
try this:
'Q'&' '&Ceil((IF(NUM(Month(DATE))>9,NUM(Month(DATE))-9,NUM(Month(DATE))+3))/3) AS [ Quarter];
hope it helps you.
Regards,
Divya
If you have only data year wise then u cannot show it quarter wise, you can create any inline table to sepecifu quarters, but u dont have data to decide whiche quarter it belongs to.
So it is never possible to show quarter wise datawith onlu year field,
or you can split the whole year data into four equar parts to show it in quarters,
but it would be unmeaningful.
-Sundar
Thank You So much to All.
If you got your answer, please close the thread by Selecting Correct - Helpful answer