Discussion board where members can get started with Qlik Sense.
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 ''
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 ?