Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ALL,
I want to write one conditional expression in QV for my chart.
In the expression i want to write something like
if(month(DateId)< Current month, actual abos,plannedabos)
Could anyone please send me the correct syntax for the same, i need this urgent.
Thanks,
Mahasweta
Hi , i wrote the expression as
sum
(if(month(DATE_ID)) < month(today),ACTUAL_ABSORPTION,PLAN_ABSORPTION)
But am not getting the desired result in my chart.
Could you please further guide me?
Thanks,
Mahasweta
sum
( if( month(DATE_ID) < month(today)
, ACTUAL_ABSORPTION
, PLAN_ABSORPTION
)
)
Hi,
I implemented the same ,still its not working.Actually am getting some value but not correct.
one idea is the Date need to be in which format, means "mm/dd/yyyyy" or what as in my database.
I mean what should be the Date type here., as in my DB i have the Date as varchar but the format is "yyyy/mm/dd".
Please suggest me here.
Thanks,
Mahasweta
Hi,
please check, whether you are using same dateformats, probably might also help to insert MonthStart-function in order to avoid disturbances with dates and timestamps.
HTH
Peter
Hi,
Could you please help me in the below expression,
i want something like
sum(if((month(Date)) < month(today),ACTUAL_ABSORPTION,' ')
means if true i should get actual abos else nothing.
How to get the else part for nothing?
Thanks,
Mahasweta
Hi,
it seems that there's a mistake with parentheses. I think it should be
Corrected:
if( (month(Date) < month(today() ) ) , ACTUAL_ABSORPTION,' ')
Rgds,
Joachim
Hi All ,
my expression is like this and am getting the values.
sum(if((month(Date)) < month(today()),ACTUAL_ABSORPTION,0))
But here the values are not coming according to the month.Here am plotting my graph Absorption vs month . So here i should get the ACTUAL_ABSORPTION with respect to the months. But am getting whole sum value here in stead of the individual value.
Please let me know where am missing.
Thanks,
Mahasweta