Some SQL subqueries are not working in qlik

[shreyansh71]

Hello Friends ,

I am trying to reload my data in qliksense cloud where I have some SQL subqueries in my script and in this some WHERE commands are not working  even am not getting any syntax error 

where FD.FILE_NO = C.FILE_NO
AND c.policy_type in ('CP_PLUS')
and C.POLICY_STATUS IN ('COI_EMAIL','COI_RCVD','COI_RECD','DISB_MADE','DOWNLOAD')
AND FD.ACTUAL_DATE between to_char((trunc((sysdate),'month')),'DD-MON-YYYY') and to_char(trunc(last_day(sysdate)),'DD-MON-YYYY');

Exit SCRIPT;

[marcus_sommer]

This part may not work like expected:

... to_char((trunc((sysdate),'month')),'DD-MON-YYYY') and
     to_char(trunc(last_day(sysdate)),'DD-MON-YYYY') ...

Therefore I suggest you remove it from the where clause and adds them entirely and also partly as fields to see how your transformations are working.

- Marcus

[shreyansh71]

Yeah, Its working now Thank you Marcus