Can anybody help me to calcule the utilization of the inventory, see the tabel
I made a selection of the order between 22/11/2014 and 28/11/2014 but the utilization must calculate with these dates.
Ordernr 1 is good
Ordernr 2 the StartDate has to be 22/11/2014
Ordernr 3 the EndDate has to be 28/11/2014
Who can help me?
Store your start and end date in separate variables:
then in dimension of your chart you can use if condition:
if(startdate> $(vStartDate) and EndDate < $(EndDate),yourDimension,null())
check the option for suppress null values.
Could you explain the result that you are trying to achieve ?
How should the StartDate/EndDate of each row contribute to the result depending on the selected period ?
Hey Tom, I built a pretty big asset utilization app to basically solve the same problem. The function I relied on most heavily was Qlikview's "IntervalMatch" which essentially takes check-in and check-out dates and creates a table of all the days where an item or asset was "out". You can then sum that field for various usage and utilization stats.
Here is an example app using intervalmatch which really helped me get started:
To get utilization, I select assets I care about, then write expressions to sum the "RentDayCounter" and divide by the number of dates selected.
Hope this helps,