If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
Hi All ,
How can I bring the record_source_gm_id as 27 ?
See the script only '27' values are present , then why the record_source_gm_id is coming null ? sample model attached.
[BORD]:LOAD//RECORD_SOURCE_GM_ID&'|'&CLAIM_NUMBER as "KEY","RB_CALENDAR_PERIOD" as "Import Month","RECORD_SOURCE_GM_ID","CLAIM_NUMBER","GROSS_CLAIMS_PAID" as "EDW Amount";SQL SELECT
[RB_CALENDAR_PERIOD],[RECORD_SOURCE_GM_ID],[CLAIM_NUMBER],[GROSS_CLAIMS_PAID]FROM [DWUQV_CLAIM_PAYMENT_TRANSACTION] where [RB_CALENDAR_PERIOD] ='2019-01-01'and RECORD_SOURCE_GM_ID in ('27');
It seems your SQL is not understanding the AND function.
Try enclosing the condition in Brackets, like below.
FROM [DWUQV_CLAIM_PAYMENT_TRANSACTION] where ([RB_CALENDAR_PERIOD] ='2019-01-01'and RECORD_SOURCE_GM_ID in ('27'));
Or consult your database admin.