topic Calculating Average Weeks and counting backwards based on Variable in QlikView

Calculating Average Weeks and counting backwards based on Variable

CB308 — Tue, 20 Apr 2010 18:00:11 GMT

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.

Calculating Average Weeks and counting backwards based on Variable

Thu, 19 Jan 2012 23:05:36 GMT

Hi Candiceb,

Do you have a the answer to this trouble? I'm trying to do the same and I'm really confused.

Thanks,

Calculating Average Weeks and counting backwards based on Variable

Mon, 28 May 2012 15:29:45 GMT

Hi,

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))