topic Conditional expression in QlickView(urgent) in QlikView

Conditional expression in QlickView(urgent)

Fri, 11 Sep 2009 12:44:37 GMT

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

Conditional expression in QlickView(urgent)

Fri, 11 Sep 2009 13:23:50 GMT

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

Conditional expression in QlickView(urgent)

Fri, 11 Sep 2009 13:46:52 GMT

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

Conditional expression in QlickView(urgent)

Fri, 11 Sep 2009 14:45:27 GMT

sum

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

, ACTUAL_ABSORPTION

, PLAN_ABSORPTION

)

Conditional expression in QlickView(urgent)

Fri, 11 Sep 2009 14:53:27 GMT

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

Conditional expression in QlickView(urgent)

prieper — Fri, 11 Sep 2009 14:58:24 GMT

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

Conditional expression in QlickView(urgent)

Fri, 11 Sep 2009 15:00:31 GMT

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

AW:Re: Conditional expression in QlickView(urgent)

biester — Fri, 11 Sep 2009 15:10:53 GMT

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

Conditional expression in QlickView(urgent)

Fri, 11 Sep 2009 15:20:15 GMT

it is today() not today

Conditional expression in QlickView(urgent)

Fri, 11 Sep 2009 16:00:59 GMT

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

Conditional expression in QlickView(urgent)

Fri, 11 Sep 2009 16:03:31 GMT

Hi,

Try this formula:

sum(if(monthstart(DateID)<=monthstart(today()) , abos, plannedabos ))

If you use function month(it will return a numbaer of the month but it will olso inlcude the months of last year. So if dateID is let's say 8/15/08 the formula will return abos in case you use month() and plannedabos in case you use monthstart(). Of course you have to take care:

1. DateID is not a key field because in QlikView these fields should not be used in formula (resuls are random). Create another Date field in case DateID is a key field.

2. Take care to have DateID, Date or whatever field you will use, formated as number or as date. If it's formated as text or string you will get an error or a wrong result.

That's it. Hope will help you.

Regards,

John