topic Re: Join not working as expected in QlikView https://community.qlik.com/t5/QlikView/Join-not-working-as-expected/m-p/978293#M334132 <HTML><HEAD></HEAD><BODY><P>Thanks Robert. What do you mean by additional spaces in the data ? Could you provide an example of what you mean ? </P></BODY></HTML> Wed, 25 Nov 2015 09:59:59 GMT 2015-11-25T09:59:59Z Join not working as expected https://community.qlik.com/t5/QlikView/Join-not-working-as-expected/m-p/978291#M334130 <HTML><HEAD></HEAD><BODY><P>I have two sheets, a and b, which have a common identifier which I am joining on. The issue is when I do the join there are some entries which should be matched but are not coming over in the join. The odd thing is if I take these entries out of sheet b and put them in a separate spreadsheet then the join works as expected. It points to some sort of issue with my excel sheet. I have removed page breaks etc and tried copying all the data from sheet b into a new sheet to no avail. </P><P></P><P>Strange one but any one any ideas ?</P></BODY></HTML> Tue, 24 Nov 2015 23:56:36 GMT https://community.qlik.com/t5/QlikView/Join-not-working-as-expected/m-p/978291#M334130 2015-11-24T23:56:36Z Re: Join not working as expected https://community.qlik.com/t5/QlikView/Join-not-working-as-expected/m-p/978292#M334131 <HTML><HEAD></HEAD><BODY><P>Are you sure the are not additional spaces somewhere in your data?</P><P></P><P></P><P>Could you post your data or app?</P></BODY></HTML> Wed, 25 Nov 2015 00:09:01 GMT https://community.qlik.com/t5/QlikView/Join-not-working-as-expected/m-p/978292#M334131 robert_mika 2015-11-25T00:09:01Z Re: Join not working as expected https://community.qlik.com/t5/QlikView/Join-not-working-as-expected/m-p/978293#M334132 <HTML><HEAD></HEAD><BODY><P>Thanks Robert. What do you mean by additional spaces in the data ? Could you provide an example of what you mean ? </P></BODY></HTML> Wed, 25 Nov 2015 09:59:59 GMT https://community.qlik.com/t5/QlikView/Join-not-working-as-expected/m-p/978293#M334132 2015-11-25T09:59:59Z