Conditional expression in QlickView(urgent)

[#1]

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

[#2]

Replace the 'Current Month' by month (today()). Will that solve your issue?

[#3]

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

[#4]

sum

( if( month(DATE_ID) < month(today)

, ACTUAL_ABSORPTION

, PLAN_ABSORPTION

)

)

[#5]

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

[prieper]

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

[#7]

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

[biester]

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

[#9]

it is today() not today

[#10]

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