topic Re: what will be the expression to create sell through in QlikView https://community.qlik.com/t5/QlikView/what-will-be-the-expression-to-create-sell-through/m-p/1416284#M814879 <HTML><HEAD></HEAD><BODY><P>is this correct?</P><P>sum(quantity sold)-sum(quantity Returns)/sum(quantity received)</P></BODY></HTML> Thu, 14 Sep 2017 11:24:29 GMT Anonymous 2017-09-14T11:24:29Z what will be the expression to create sell through https://community.qlik.com/t5/QlikView/what-will-be-the-expression-to-create-sell-through/m-p/1416282#M814877 <HTML><HEAD></HEAD><BODY><P>Hi </P><P>what will be the expression for obtaining sell through on basis of a particular columns .the data should be received in indian rupee rate <IMG alt="desktopimage.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/176552_desktopimage.png" style="height: auto;" /></P><P>Please help</P><P>Thanks in advance </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/what-will-be-the-expression-to-create-sell-through/m-p/1416282#M814877 Anonymous 2020-11-25T16:16:04Z Re: what will be the expression to create sell through https://community.qlik.com/t5/QlikView/what-will-be-the-expression-to-create-sell-through/m-p/1416283#M814878 <HTML><HEAD></HEAD><BODY><P>Hi Saksham,</P><P></P><P>You need to calculate sale like below:</P><P></P><P></P><P>(Sum(Quantity)*(Sum(Price)*Exchange Rate) )As <STRONG>Sale</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG>Thanks,</STRONG></P><P><STRONG>Arvind Patil</STRONG></P></BODY></HTML> Thu, 14 Sep 2017 11:05:17 GMT https://community.qlik.com/t5/QlikView/what-will-be-the-expression-to-create-sell-through/m-p/1416283#M814878 arvind_patil 2017-09-14T11:05:17Z Re: what will be the expression to create sell through https://community.qlik.com/t5/QlikView/what-will-be-the-expression-to-create-sell-through/m-p/1416284#M814879 <HTML><HEAD></HEAD><BODY><P>is this correct?</P><P>sum(quantity sold)-sum(quantity Returns)/sum(quantity received)</P></BODY></HTML> Thu, 14 Sep 2017 11:24:29 GMT https://community.qlik.com/t5/QlikView/what-will-be-the-expression-to-create-sell-through/m-p/1416284#M814879 Anonymous 2017-09-14T11:24:29Z