topic Re: Calculate margin in an expression? in QlikView https://community.qlik.com/t5/QlikView/Calculate-margin-in-an-expression/m-p/1220003#M861306 <HTML><HEAD></HEAD><BODY><P>The fields I assumed are required for calculating margin are all in one table, except for one field which is in another table. But I figured if I do the calculating in an expression I wouldn't have to join tables right?</P><P></P><P>These are the fields I assume I should work with: SalesPrice, Amount (sold), Rebate, SalesCost</P></BODY></HTML> Mon, 09 Jan 2017 22:43:02 GMT 2017-01-09T22:43:02Z Calculate margin in an expression? https://community.qlik.com/t5/QlikView/Calculate-margin-in-an-expression/m-p/1220001#M861304 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I wonder if it's possible to calculate margins in an expression or of it has to be done in the tables?</P><P></P><P>If it's possible to do with an expression, how do I go about doing that?</P><P></P><P>Thanks</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Calculate-margin-in-an-expression/m-p/1220001#M861304 2020-11-25T16:16:04Z Re: Calculate margin in an expression? https://community.qlik.com/t5/QlikView/Calculate-margin-in-an-expression/m-p/1220002#M861305 <HTML><HEAD></HEAD><BODY><P>How does your date look like? I am sure it is possible, just need to work with what we have? Can you share a sample or sample data?</P></BODY></HTML> Mon, 09 Jan 2017 22:23:09 GMT https://community.qlik.com/t5/QlikView/Calculate-margin-in-an-expression/m-p/1220002#M861305 sunny_talwar 2017-01-09T22:23:09Z Re: Calculate margin in an expression? https://community.qlik.com/t5/QlikView/Calculate-margin-in-an-expression/m-p/1220003#M861306 <HTML><HEAD></HEAD><BODY><P>The fields I assumed are required for calculating margin are all in one table, except for one field which is in another table. But I figured if I do the calculating in an expression I wouldn't have to join tables right?</P><P></P><P>These are the fields I assume I should work with: SalesPrice, Amount (sold), Rebate, SalesCost</P></BODY></HTML> Mon, 09 Jan 2017 22:43:02 GMT https://community.qlik.com/t5/QlikView/Calculate-margin-in-an-expression/m-p/1220003#M861306 2017-01-09T22:43:02Z