Discussion Board for collaboration related to Creating Analytics for QlikView.
Hi all ,
I have a table which has sales and Inventory.
I need to show the total sales for a certain time frame (week/year) and inventory as well, but also an average inventory.
If I select Year 2010 and Weeks 13, 14, 15 and 16 but use a variable for the number of weeks I want to use for Average Inventory what expression do I use?
Average Week Variable = 2 ( Inventory / inventory for weeks 15 and 16? )
How do I find and calculate week 16 and 15 average inventory? from week number = 16 (the highest number selected in the select data range)
If the Variable was 3, then I would need Total Inventory for the time frame chosen divided by the sum of Inventory weeks 16, 15 and 14.
Any assistance would be much, much appreciated.
Do you have a the answer to this trouble? I'm trying to do the same and I'm really confused.
This may help you a little bit, I use it for calculating the weeks of inventory base on average sales for previous 13 weeks.
Sum ([Inventory]) / RangeAvg( Before( SUM([Sales]),0,13))