topic Re: Regarding condition in QlikView

Regarding condition

sarfaraz_sheikh — Fri, 13 Feb 2015 13:56:58 GMT

Dear All,

Whats wrong i am doing in below expression.. always the control is going in else part ...the condition found false everytime..

what i needs to do for condition being true.

Date(if(CREATE_DATE>=20150114,OPS_INWD_RECEIEVE_DATE,CREATE_DATE),'YYYYMMDD') AS Create_Date_Originl

Date(if(CREATE_DATE>='20150114',OPS_INWD_RECEIEVE_DATE,CREATE_DATE),'YYYYMMDD') AS Create_Date_Originl

Regards

Sarfaraz

Michiel_QV_Fan — Fri, 13 Feb 2015 13:59:39 GMT

CREATE_DATE>=20150114

This part should be formatted as date because it's compared with a field that is defined as date (i presume) OPS_INWD_RECEIEVE_DATE.

20150114 is a number.

date(date#('20150114', 'YYYYMMDD'), 'MM-DD-YYYY') or your default date format

Anonymous — Fri, 13 Feb 2015 14:38:09 GMT

Hi,

It depends on your date format, but I think you should use:

Date(if(date(CREATE_DATE)>=date('14/01/2015'),OPS_INWD_RECEIEVE_DATE,CREATE_DATE),'YYYYMMDD') AS Create_Date_Originl

sarfaraz_sheikh — Fri, 13 Feb 2015 14:40:41 GMT

Thanks van de goor.....great solution working fine now as expected ......

Sarfaraz