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.