topic Re: formula for calculating sell through in QlikView

formula for calculating sell through

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I have two columns purchase quantity and sales quantity

Purchase_quantity= total quantity/1 as Purchase quantity ( in load script)

sales quantity=total quantity/1 as sales quantity(in load script)

In chart expression

what will be the expression for calculating sell through if I have sales quantity and purchase quantity

devarasu07 — Mon, 18 Sep 2017 06:07:36 GMT

Hi,

in General Sell Through % formula is like that,

=sum(SoldQty)/sum({<PO_Type={'NB'}>} OrderQty)

Note:

OrderQty from Purchase Order Fact Table.

SoldQty from Sales Fact Table

PO Type : NB which is initial order. based on your flag and requirement u can use it.

P.S; u check with your Business User for the Confirmation.

Thanks,

Deva