Average Inventory calculation

Wed, 17 Nov 2010 23:46:01 GMT

Hi,

I'm new to Qlikview and having issues with trying to figure out set analysis to accomplish inventory turnover. Basically what I'm trying to do is calculate the Average inventory for a given period (period being a month). I need to sum the beginning inventory value and sum the ending inventory value but I don't know how to use set analysis to accomplish this task.

In the report I would like to select a month then need to determine the first date of the month and sum the inventory value from the beginning of time to the beginning of the month only problem is I don't know how to use set analysis to calculate a value from the beginning of time to the current date selected. I think if I got that far I could calculate the inventory turnover properly.

I can provide other details if needed.

Thanks.

Average Inventory calculation

johnw — Thu, 18 Nov 2010 00:26:10 GMT

Maybe this?

rangeavg(sum({<Date={"<$(=monthstart(max(Date)))"}>} InventoryChange)
,sum({<Date={"<=$(=date(max(Date)))"}>} InventoryChange))

topic Average Inventory calculation in QlikView

Average Inventory calculation

Average Inventory calculation