Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
suvechha_b
Creator III
Creator III

Please assist , not linking correctly ?

Hi All ,

How can I bring the record_source_gm_id as 27 ?

img.PNG

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');

1 Reply
kaushiknsolanki

Hi,

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.

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".