Qlik Sense Dynamic View Oracle Giving Error Illegal Zero Length Identifier

piyush_s11 — Fri, 15 Nov 2024 23:37:16 GMT

Hi,

I am getting illegal zero length identifier error while connecting to oracle database. I making dynamic view.

I have observed that the error seems to be in the where clause of script. please find below script I am using.

SQL SELECT "COB_DATE",

"DEPOT_ID",

"GBM_ATOM_CODE",

"GBM_DEPT",

"BOOK_SHORT_CODE",

"BOOK_DESC",

"DTD_PL_FCCY",

"MTD_PL_FCCY",

"DTD_MM_FCCY",

"DTD_NT_FCCY",

"DTD_VAL_FCCY",

"DTD_PROV_FCCY",

"DTD_CARRY_FCCY",

"DTD_FEE_FCCY",

"DTD_PLTR_FCCY",

"MTD_MM_FCCY",

"MTD_NT_FCCY",

"MTD_VAL_FCCY",

"MTD_PROV_FCCY",

"MTD_CARRY_FCCY",

"MTD_FEE_FCCY",

"MTD_PLTR_FCCY",

"LAST_MODIFIED"

FROM "PCIT_CORE"."CORE_PL_GPL"//;

WHERE "COB_DATE" IN ($(odags_COB_DATE){"quote": ""})

AND GBM_DEPT IN ($(odags_GBM_DEPT){"quote": ""});

Please help.

@avinashelite, @kushalthakral, @tresesco, @prabir_c, @eliran, @ts_anandrjs, @MK_QSL, @Anbu1984, @Marcus_sommer, @Daniel_kusiak,

Thanks in Advance.

topic Qlik Sense Dynamic View Oracle Giving Error Illegal Zero Length Identifier in Visualization and Usability