topic Re: Join validation in QlikView https://community.qlik.com/t5/QlikView/Join-validation/m-p/736225#M1065174 <HTML><HEAD></HEAD><BODY><P>If you do not have any business rule on which these 2 table will be joined, then there is no way to get the expected results.</P><P></P><P>I would request you to redefine the way you want to link these tables.</P><P></P><P>Thanks,</P><P>Singh</P></BODY></HTML> Fri, 19 Sep 2014 05:41:20 GMT 2014-09-19T05:41:20Z Join validation https://community.qlik.com/t5/QlikView/Join-validation/m-p/736221#M1065168 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>I have 2 table and I don't have any primary key between both the tables...</P><P>And its must to join both the table in this way by which I get correct validation result...</P><P></P><P>Please find the attached files for details..</P><P>I want salary should come correct after joining...</P><P></P><P>Please reply..</P><P></P><P>Rahul</P></BODY></HTML> Fri, 19 Sep 2014 05:25:33 GMT https://community.qlik.com/t5/QlikView/Join-validation/m-p/736221#M1065168 2014-09-19T05:25:33Z Re: Join validation https://community.qlik.com/t5/QlikView/Join-validation/m-p/736222#M1065169 <HTML><HEAD></HEAD><BODY><P>This is how join works. To get your desired result, just keep the tables associated (No join).</P></BODY></HTML> Fri, 19 Sep 2014 05:40:04 GMT https://community.qlik.com/t5/QlikView/Join-validation/m-p/736222#M1065169 tresB 2014-09-19T05:40:04Z Re: Join validation https://community.qlik.com/t5/QlikView/Join-validation/m-p/736223#M1065171 <HTML><HEAD></HEAD><BODY><P>Try this</P><P>=Sum(Aggr(Max(DISTINCT Salary),ID))</P></BODY></HTML> Fri, 19 Sep 2014 05:40:07 GMT https://community.qlik.com/t5/QlikView/Join-validation/m-p/736223#M1065171 anbu1984 2014-09-19T05:40:07Z Re: Join validation https://community.qlik.com/t5/QlikView/Join-validation/m-p/736224#M1065173 <HTML><HEAD></HEAD><BODY><P>in the expression:</P><P>Sum(Aggr(Salary, NAME))</P></BODY></HTML> Fri, 19 Sep 2014 05:40:50 GMT https://community.qlik.com/t5/QlikView/Join-validation/m-p/736224#M1065173 Anonymous 2014-09-19T05:40:50Z Re: Join validation https://community.qlik.com/t5/QlikView/Join-validation/m-p/736225#M1065174 <HTML><HEAD></HEAD><BODY><P>If you do not have any business rule on which these 2 table will be joined, then there is no way to get the expected results.</P><P></P><P>I would request you to redefine the way you want to link these tables.</P><P></P><P>Thanks,</P><P>Singh</P></BODY></HTML> Fri, 19 Sep 2014 05:41:20 GMT https://community.qlik.com/t5/QlikView/Join-validation/m-p/736225#M1065174 2014-09-19T05:41:20Z