topic Re: Many to Many Relationship in QlikView https://community.qlik.com/t5/QlikView/Many-to-Many-Relationship/m-p/1124750#M894441 <HTML><HEAD></HEAD><BODY><P>Please post sample data </P></BODY></HTML> Wed, 03 Aug 2016 20:47:35 GMT maheshkuttappa 2016-08-03T20:47:35Z Many to Many Relationship https://community.qlik.com/t5/QlikView/Many-to-Many-Relationship/m-p/1124749#M894440 <HTML><HEAD></HEAD><BODY><P>I have two table.</P><P>The first table is PolicyTable, with fields: PolicyNbr, IssueDate, ExpireDate, Product, Channel, Premium. The policyNbr is a unique number.</P><P>The second table is ClaimTable, with fields: ClaimNbr, PolicyNbr, ReportDate, PaymentDate, PaymentAmount. This is a transaction record table, there is no primary key field. A claim could have multiple policies and multiple payments. A policy could also have multiple claims.</P><P></P><P>The questions I want to solve are,</P><P>On a&nbsp; evaluate date,</P><P>1) How many policies have claims? </P><P>2) How many claims does each policy have?</P><P></P><P>The difficulty I have here is the many to many relationship between PolicyNbr and ClaimNbr. I don't know what's the most efficient way to do the analysis.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Many-to-Many-Relationship/m-p/1124749#M894440 2020-11-25T16:16:04Z Re: Many to Many Relationship https://community.qlik.com/t5/QlikView/Many-to-Many-Relationship/m-p/1124750#M894441 <HTML><HEAD></HEAD><BODY><P>Please post sample data </P></BODY></HTML> Wed, 03 Aug 2016 20:47:35 GMT https://community.qlik.com/t5/QlikView/Many-to-Many-Relationship/m-p/1124750#M894441 maheshkuttappa 2016-08-03T20:47:35Z