topic Re: Divide 2 fields in QlikView https://community.qlik.com/t5/QlikView/Divide-2-fields/m-p/314822#M708422 <HTML><HEAD></HEAD><BODY><P>Use resident load, see attached</P></BODY></HTML> Tue, 20 Dec 2011 14:59:53 GMT 2011-12-20T14:59:53Z Divide 2 fields https://community.qlik.com/t5/QlikView/Divide-2-fields/m-p/314820#M708420 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have a script consisting of several joins. I want to add a calculated field in the end, where I devide the value of 2 fields. My problem is that when deviding the key field is not taken into account. See attached file.</P><P>I would expect a result with 3 rows - one row for each article. Please help.</P></BODY></HTML> Tue, 20 Dec 2011 14:49:29 GMT https://community.qlik.com/t5/QlikView/Divide-2-fields/m-p/314820#M708420 2011-12-20T14:49:29Z Divide 2 fields https://community.qlik.com/t5/QlikView/Divide-2-fields/m-p/314821#M708421 <HTML><HEAD></HEAD><BODY><P>I think you need to use the Article field in your last left join:</P><P></P><P>left join (Data)</P><P>load Article,</P><P>&nbsp;&nbsp;&nbsp; Qty/BoxSize as NumberBoxes</P><P>Resident Data;</P></BODY></HTML> Tue, 20 Dec 2011 14:58:29 GMT https://community.qlik.com/t5/QlikView/Divide-2-fields/m-p/314821#M708421 swuehl 2011-12-20T14:58:29Z Re: Divide 2 fields https://community.qlik.com/t5/QlikView/Divide-2-fields/m-p/314822#M708422 <HTML><HEAD></HEAD><BODY><P>Use resident load, see attached</P></BODY></HTML> Tue, 20 Dec 2011 14:59:53 GMT https://community.qlik.com/t5/QlikView/Divide-2-fields/m-p/314822#M708422 2011-12-20T14:59:53Z