% availability

Thu, 13 Sep 2012 09:17:46 GMT

Good afternoon.

It is necessary to calculate the% availability, ie

Number of dates where the stock higher than the average sales divided by the number of days in the period, we get% availability

Average sale is the sum of the last 20 sales division by 20, his status is 1 and a check equal to 1

Should get a table

SalesMan	% availability
Stiv	10%
Ivan	58%
Abram	62%

Embedded sample data model

Re: % availability

Fri, 14 Sep 2012 13:15:50 GMT

The result here is that expression, but it works somehow strange when cleaned selections, the result of an underestimate, as selected seller, all appears fine

What are some ideas?

Count({$<Count_Stock={">=$(=Sum({<Date={">=$(=

Date(If(

IsNull(

FirstSortedValue({<Count={">0"},Status={"1"},Check={"1"}>} Date, -Date, 20)),

Min({<Count={">0"},Status={"1"},Check={"1"}>}Date),

FirstSortedValue({<Count={">0"},Satus={"1"},Check={"1"}>} Date, -Date, 20))

))"},Count={">0"},Status={"1"},Check1={"1"}>} Count

)

/If(

IsNull(

FirstSortedValue({<Count={">0"},Status={"1"},Check={"1"}>} Date, -Date, 20)),

Count({<Date={">=$(=Min({$<Count={">0"},Status={"1"},Check={"1"}>}Date))"},Count={">0"},Status={"1"},Check={"1"}>}distinct Date),20))"}>} DISTINCT Date)

Count(DISTINCT Date)

topic Re: % availability in QlikView

% availability

Re: % availability