topic Calculating Fill rate in QlikView

Calculating Fill rate

Fri, 25 Jul 2014 07:14:38 GMT

Hello, I am very new to QV and have a problem I can't manage to figure out so far.

Here it is: I have a number of records and I need to calculate how many of them are in the 90

I want to know the value of [order to supplier ship] which is a measurement in days when the count of [order_no] has passed 90%

I used to do this in Excel with a pivot table and some formulas and the results looked like this:

Order to supplier ship (days)	Count of order_no	Cumulative Count	% filled	90% FR
1	151	151	36.47%	2.49
2	201	352	85.02%
3	42	394	95.17%
4	14	408	98.55%
5	5	413	99.76%
6	1	414	100.00%
Grand Total	414

So this output here told me that for my 414 orders, it took 2.49 days to achieve the 90% fill rate.

in QV, I am not sure what functions I should be able to use to calculate this, I was playing around with FRACTILE, but so far I can not figure it out.

Re: Calculating Fill rate

MK_QSL — Fri, 25 Jul 2014 08:02:06 GMT

RangeSum(Above(SUM(Orders),0,RowNo()))/Sum(TOTAL Orders)

Re: Calculating Fill rate

Fri, 25 Jul 2014 08:20:40 GMT

thanks for the quick response, perhaps I did not structure my question correctly.

I don't want to run the formula against that pivot table output, I want to recreate the 2.49 value using a QV formula that checks all the records, counting the "Orders", and giving the "order to suppliership" value in days.

each cycle, there could be a different number of orders, depending on overall volume...