
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Average Inventory calculation
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.
- Tags:
- new_to_qlikview


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Maybe this?
rangeavg(sum({<Date={"<$(=monthstart(max(Date)))"}>} InventoryChange)
,sum({<Date={"<=$(=date(max(Date)))"}>} InventoryChange))
