Current/Historical data comparrison

Anonymous — Tue, 07 Oct 2014 06:49:39 GMT

Hi all,

I'm working with data which is daily uploaded from a live data source (stock data).

I've created a table with the stock of a certain set of items (last mutation date = 12-13 weeks ago)

"Refer to this as the selection date"

Now(say 8 weeks later), I would like to create a table which tracks the development in stock over this set of items.

So, something like the following

Selection date	selection date + 4 weeks	Selection date + 8 weeks
# of stock for item 1 at selection date	# of stock for item 1 at selection date + 4 weeks	# of stock for item 1 at selection date +8weeks
# of stock for item 2 at selection date	# of stock for item 2 at selection date + 4 weeks	# of stock for item 2 at selection date +8weeks
# of stock for item 3 at selection date	# of stock for item 3 at selection date + 4 weeks	# of stock for item 3 at selection date +8weeks

I realize it's still a bit vague, but can anyone help me to create something like this. I think I need to store historical data on a weekly basis(with a week&year reference) such that I can load this data into a table like the one above.

Many thanks in advance.

topic Current/Historical data comparrison in QlikView

Current/Historical data comparrison