topic Re: Join issue. in QlikView https://community.qlik.com/t5/QlikView/Join-issue/m-p/1392849#M612979 <HTML><HEAD></HEAD><BODY><P>Maybe don't join the tables, just keep them linked by account number.</P></BODY></HTML> Wed, 04 Oct 2017 11:52:30 GMT swuehl 2017-10-04T11:52:30Z Join issue. https://community.qlik.com/t5/QlikView/Join-issue/m-p/1392848#M612978 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have to make a join on a field(Account number) that has multiple values, I need to join and pick up an amount from the other table. </P><P></P><P>Due to multiple occurances of account number I am getting the amount counted multiple times. How would I restrict the amount to show only once? </P><P></P><P>I need to further calculations based on the account number.</P><P></P><P>thanks.</P></BODY></HTML> Wed, 04 Oct 2017 11:39:57 GMT https://community.qlik.com/t5/QlikView/Join-issue/m-p/1392848#M612978 qliktech_uk 2017-10-04T11:39:57Z Re: Join issue. https://community.qlik.com/t5/QlikView/Join-issue/m-p/1392849#M612979 <HTML><HEAD></HEAD><BODY><P>Maybe don't join the tables, just keep them linked by account number.</P></BODY></HTML> Wed, 04 Oct 2017 11:52:30 GMT https://community.qlik.com/t5/QlikView/Join-issue/m-p/1392849#M612979 swuehl 2017-10-04T11:52:30Z Re: Join issue. https://community.qlik.com/t5/QlikView/Join-issue/m-p/1392850#M612980 <HTML><HEAD></HEAD><BODY><P>But I get incorrect results when I make selections.</P></BODY></HTML> Wed, 04 Oct 2017 12:50:39 GMT https://community.qlik.com/t5/QlikView/Join-issue/m-p/1392850#M612980 qliktech_uk 2017-10-04T12:50:39Z Re: Join issue. https://community.qlik.com/t5/QlikView/Join-issue/m-p/1392851#M612981 <HTML><HEAD></HEAD><BODY><P>which join are you exactly using ?</P><P></P><P>share sample data or app if possible.</P><P></P><P>regards</P><P>Pradosh</P></BODY></HTML> Wed, 04 Oct 2017 15:46:31 GMT https://community.qlik.com/t5/QlikView/Join-issue/m-p/1392851#M612981 pradosh_thakur 2017-10-04T15:46:31Z