Skip to main content

Qlik Cloud Data Integration

Discussion Board to explore in-depth resources and chat with Qlik Cloud Data Services experts from around the globe.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
shreyansh71
Contributor II
Contributor II

Some SQL subqueries are not working in qlik

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;

 

 

Labels (3)
2 Replies
marcus_sommer
MVP & Luminary
MVP & Luminary

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
Contributor II
Contributor II
Author

Yeah, Its working now Thank you Marcus