Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
QlikBeginner1
Creator
Creator

Qlik Table Matching issue

Hello,

I have a table where essentially the table is highlighted where measures are being matched. I have a dimension which is matching but due to being on different systems, they are coming as different figures and coming through as a not match. Please see example below

QlikBeginner1_0-1604318009286.png

The issue I have with the GWP Match columns is that it works when - for example - i only look at the GWP for Policy Number and it is not split by Product, as its only one record per policy then, however when its split by mulitple Products, it does not work. I have highlighted what should be matching in green and what shouldnt in red.

Any suggestions? the expression i am currently using for the non matching column is :

If(round(Sum({$<TransactionPremSourceSystemName={'Acturis BE'}>}GrossWrittenPremium),0.01)
=
Round(Sum({$<TransactionPremSourceSystemName={'COGEN'},ActurisFlag={1}>}GrossWrittenPremium),0.01), 'Matching','Not Matching')

This is an example of when the matching does work:

QlikBeginner1_0-1604318257859.png

 

Labels (2)
0 Replies