https://community.qlik.com/t5/App-Development/Improper-SQL-generation-in-Qliksense-Direct-Discovery/m-p/2142738#M93002 <P><SPAN>Hi Team ,</SPAN><BR /><BR /><SPAN>Improper SQL is generated in Qlik sense Direct Discovery.</SPAN><BR /><BR />Numeric count calculation is done even we are not using in expression.</P> <P><BR /><STRONG>SELECT NUMERICCOUNT(DISTINCT "V_DQ_REPORT_GNRTR_PROD_EVENT_MKT"."PTNT_GID"), COUNT(DISTINCT "V_DQ_REPORT_GNRTR_PROD_EVENT_MKT"."PTNT_GID") FROM "CPA_DEV"."CPA"."V_DQ_REPORT_GNRTR_PROD_EVENT_MKT" WHERE "V_DQ_REPORT_GNRTR_PROD_EVENT_MKT"."DLVRB_GID" = 578628 AND "V_DQ_REPORT_GNRTR_PROD_EVENT_MKT"."PRD_NBR" IN ( 26, 27, 28, 29 )</STRONG><BR /><BR /><SPAN>Operating System: Windows</SPAN><BR /><SPAN>Operating System Version: 2019</SPAN><BR /><SPAN>Product Release: May 2023</SPAN><BR /><SPAN>Environment Type: Test<BR /><BR /></SPAN><BR /><SPAN>kindly assist here</SPAN></P> Fri, 15 Nov 2024 21:12:50 GMT MohanRo 2024-11-15T21:12:50Z https://community.qlik.com/t5/App-Development/Improper-SQL-generation-in-Qliksense-Direct-Discovery/m-p/2142738#M93002 <P><SPAN>Hi Team ,</SPAN><BR /><BR /><SPAN>Improper SQL is generated in Qlik sense Direct Discovery.</SPAN><BR /><BR />Numeric count calculation is done even we are not using in expression.</P> <P><BR /><STRONG>SELECT NUMERICCOUNT(DISTINCT "V_DQ_REPORT_GNRTR_PROD_EVENT_MKT"."PTNT_GID"), COUNT(DISTINCT "V_DQ_REPORT_GNRTR_PROD_EVENT_MKT"."PTNT_GID") FROM "CPA_DEV"."CPA"."V_DQ_REPORT_GNRTR_PROD_EVENT_MKT" WHERE "V_DQ_REPORT_GNRTR_PROD_EVENT_MKT"."DLVRB_GID" = 578628 AND "V_DQ_REPORT_GNRTR_PROD_EVENT_MKT"."PRD_NBR" IN ( 26, 27, 28, 29 )</STRONG><BR /><BR /><SPAN>Operating System: Windows</SPAN><BR /><SPAN>Operating System Version: 2019</SPAN><BR /><SPAN>Product Release: May 2023</SPAN><BR /><SPAN>Environment Type: Test<BR /><BR /></SPAN><BR /><SPAN>kindly assist here</SPAN></P> Fri, 15 Nov 2024 21:12:50 GMT https://community.qlik.com/t5/App-Development/Improper-SQL-generation-in-Qliksense-Direct-Discovery/m-p/2142738#M93002 MohanRo 2024-11-15T21:12:50Z