Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

compare the EDW Amount and Bord Amt per Claim Number ?

Hi All ,

I got a sample model attached . Please kindly assist me in doing a report like below description-

My requirement is - I have to compare the EDW Amount and Bord Amt per Claim Number for Import month '2019-01-01' for record_source_gm_id.

Say for example , 'Claim Number' - 1 has 'EDW Amount' as '1000' but 'Bord Amt' has '1100' for the sample 'Import Month' '2019-01-01' for record source ''

Capture.PNG

Do I have to create a key by joining 'Claim Number','Import Month' and 'record Source Gm Id' ?

Please also assist me in concat the three in the script ?

I am getting the result correct , but how to show the Record Source GM ID ?

Capture1.PNG