topic Some SQL subqueries are not working in qlik in Data Movement & Streaming

Some SQL subqueries are not working in qlik

shreyansh71 — Wed, 19 Mar 2025 23:08:30 GMT

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;

Re: Some SQL subqueries are not working in qlik

marcus_sommer — Wed, 18 May 2022 06:24:47 GMT

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

Re: Some SQL subqueries are not working in qlik

shreyansh71 — Thu, 19 May 2022 04:54:23 GMT

Yeah, Its working now Thank you Marcus