Need help in converting sql condition to qlik

[chinnu123]

Hi Experts,

I  need your help in converting sql condition to qlik.

Here is my condition  

CASE WHEN TRUNC(start_ date) < TO_DATE('2016-04-30 00:00:00','yyyy-mm-dd hh24:mi:ss') THEN  status_complete WHEN status_complete='Y' ANDCDD_COMP_FLAG=1 THEN 'X' ELSE '' END CDD_Complete

The above condition in sql I need to convert that into qlik. here start date,to_date and status_complete are the fields.

Can any one please help on this

Thanks in advance,

Thanks,

Chinnu.

[chinnu123]

Hi Sunny,

Thanks for your Help.

Thanks,

Chinnu.