Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
i have one calendar scenario for Quarter,
Cal:
Load * Inline
[Month,MNO,QTR
A,4,AMJ
M,5,AMJ
J,6,AMJ
J,7,JAS
A,8,JAS
S,9,JAS
O,10,OND
N,11,OND
D,12,OND
J,1,JFM
F,2,JFM
M,3,JFM];
Pick(Match(Upper((QTR)),'JAS','OND','JFM','AMJ'),9,12,3,6),
NOTE: JAS stands July, Aug, Sep
OND stands Oct,Nov,Dec
JFM Stands Jan,Feb, Mar
AMJ Stands Apr,May,Jun
Above is my condition i want the output like , let suppose my current month is Feb, it means i m in JFM quarter, it should check always current month and return the value for the same. for feb i.e 2. In march it should be 3 and so on. but apart from current QTR the value should be as defined in Pick Match logic. e.g. for JAS :9, for OND:12, for AMJ, 6,
Any suggestions
Hi abhay,
i am not clear what you want exactly, but i think you should
use something like this:
(Ceil(MNO,3)*3) instead of pick for the 3, 6, 9 or 12 value.
also for the other values, you can just use Ceil(MNO,3) for quarter numbers.
it is not specific what you want, if this is not what yo want, please specify it more clearly.
Best regards,
Dick
Hi,
Actualy the data I have is in below format
QTR
JAS
OND
JFM
AMJ
Now I m giving each QTR a number which is like Pick(Match(Upper((QTR)),'JAS','OND','JFM','AMJ'),9,12,3,6)
It check when showing data for any QTR let SAY, JAS it will return the output 9 .
but in the same scenario, for eg JFM , I have assigned the value 3(as per last month of the QTR) , but currently we are sitting in Feb so I want it should return me 2 instead of 3.
Hope I am able to explain .
thanks in advance
so as i understand correctly, your month numbers do not mach with the numbers returning from your table?
why do you not left join an index on months on your QTR table and make a key linking months and qtr?
it will show as following table.
M, QTR, MQTR, NO
J, JAS, J-JAS, 7
A, JAS, A-JAS, 8
S, JAS, S-JAS, 9
Can you please attach an example .qvw file for better understanding?
Best regards,
Dick
any suggestions ?