Hi Team ,
Improper SQL is generated in Qlik sense Direct Discovery.
Numeric count calculation is done even we are not using in expression.
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 )
Operating System: Windows
Operating System Version: 2019
Product Release: May 2023
Environment Type: Test
kindly assist here