topic Re: How to Calculate Contribution % of Inventory cover in QlikView

How to Calculate Contribution % of Inventory cover

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

Hi,

Currently, I am calculating the Inventory cover like below:

Now, I need to calculate the Inventory cover contribution.

((Sum({$<[Transaction Date]={"$(vMaxDepotDate)"}>}[Depot Stock])+

Sum({$<[Transaction Date]={"$(vMaxProductionDate)"}>}[Production Stock])+

Sum({$<[Transaction Date]={"$(vMaxProductionDate)"}>}[Blocked Stock])+

Sum({$<[Transaction Date]={"$(vMaxProductionDate)"}>}[Stock in Transit])+

Sum({$<[Transaction Date]={"$(vMaxProductionDate)"}>}[Stock at Quality])+

Sum({$<[Transaction Date]={"$(vMaxProductionDate)"}>}[Total Valuated Stock])+

Sum({$<[Transaction Date]={"$(vMaxProductionDate)"}>}[Unrestricted Stock]))

RangeAvg(sum({$<[Transaction Date]={"<=$(=Date(vMaxSalesDate))$(=Date(vMaxSalesDate-6))"},[Sales Volume]={">=0"}>}[Sales Volume]),

sum({$<[Transaction Date]={"<=$(=Date(vMaxSalesDate-7))>=$(=Date(vMaxSalesDate-13))"},[Sales Volume]={">=0"}>}[Sales Volume]),

sum({$<[Transaction Date]={"<=$(=Date(vMaxSalesDate-14))>=$(=Date(vMaxSalesDate-20))"},[Sales Volume]={">=0"}>}[Sales Volume]),

sum({$<[Transaction Date]={"<=$(=Date(vMaxSalesDate-21))>=$(=Date(vMaxSalesDate-28))"},[Sales Volume]={">=0"}>}[Sales Volume])))*6.5

Can you please let me know if have any solutions for this.

Required Table:

% = Inventory Cover in Days/ Total Inventory Cover in days

fabdulazeez — Mon, 30 Jul 2018 05:34:14 GMT

Use Total qualifier to get Total inventory cover (perform an aggregation across all dimensions)

rangam_s — Mon, 30 Jul 2018 05:37:49 GMT

Can you please give me an expression for this.

Thanks for your helping hand.

BalaBhaskar_Qlik — Mon, 30 Jul 2018 07:15:25 GMT

It could be like this:

Sum({$<[Transaction Date]={"$(vMaxDepotDate)"}>}[Depot Stock])

Sum(TOTAL {$<[Transaction Date]={"$(vMaxDepotDate)"}>}[Depot Stock])

Add your remaining expressions into this.

rangam_s — Mon, 30 Jul 2018 07:45:26 GMT

Thanks for your help.

I got the answer.

rangam_s — Mon, 30 Jul 2018 08:00:09 GMT

(((Sum({$<[Transaction Date]={"$(vMaxDepotDate)"}>}[Depot Stock])+